RE: Restarting CF from Web
Starting and stoping CF will generally require root/administrator access in default install. If you take the following suggestions make sure you're aware of how to exec system commands safely in a web accessible script. *NIX: - If your under *nix w/ Perl or PHP support; change to a user w/ permissions to control the CF process then run $CF_root/bin/start and stop (default is /opt/coldfusion). WIN32: -- Under NT w/ Perl, PHP, or ASP support; change to a user w/ permissions to control the CF process then run: NET START Cold Fusion Executive NET START Cold Fusion Application Server NET START Cold Fusion RDS I think I have the correct order, there's a cycle.bat or something under %CF_root%\bin\ that will provide the correct order if I'm mistaken. Reverse order for NET STOP. If you don't have knowledge of these languages and you'd like a Perl or PHP script for *nix/NT I can whip you up one on request, or if you run Webmin I've made a quick module for it (nothing fancy at all, purely for my own use when no SSH is available). If you're IIS on NT someone w/ more knowledge than I could probably make a quick ASP script for you. -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: May 11, 2001 08:31 To: CF-Talk Subject: Restarting CF from Web Hello! In CF 4.0 there was a nifty java app that allowed me to stop and restart CF from a web page, however it is no more in 4.5. I no longer have a copy of 4.0 and really need to get a copy of this. Does anyone have a resource to get this or an alternative that will do the same thing? Thanks! Tim Painter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
Heh, Could have saved myself some time by simply RTFM! Never mind, its always useful to see how someone else architects things: (From componentkit.pdf) Two mechanisms were evaluated for passing information from Macromedia ColdFusion to Macromedia Flash. One involved passing variables in over the URL to the Macromedia Flash object. The other involved using the Macromedia Flash loadVariables command to have each component read information through a separate HTTP request. Depending on the browser and operating system, there may be a limit to the number of characters that can be strung on the end of a SWF's URL, ranging from 2K to 4K characters. Because of this limitation, our design uses the Macromedia Flash loadVariables command to pull information from a separate Macromedia ColdFusion file. When a Component Kit component is instantiated, Macromedia ColdFusion holds the parameter information in the Macromedia ColdFusion server scope, loads the Macromedia Flash movie for the component, and passes a callback URL into the Macromedia Flash movie. This callback URL, which points to fetchdata.cfm, allows the instantiated Macromedia Flash movie to retrieve its specific information using Macromedia Flash loadVariables. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 07:56 To: CF-Talk Subject: RE: Harpoon Release is Final Available From the looks of it (without going into too much detail), the flash movie uses the loadvariables command on a callback url which calls the variables from a unique server scoped variable created for that instance of the page call only. Put all variables into unique server scoped struct Call Flash Movie with a callback to: Seperate template that decides which component is being used and dumps the server variables in a format Flash can read using its loadVariables command. Dunno what it does from there cos I haven't got Flash 5 (I'll have to ask our Macatistas (design bods) here in the office) but basically Flash is reading the variables from a text file. That's my basic understanding anyway. Might have got little bits wrong. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 18:47 To: CF-Talk Subject: Re: Harpoon Release is Final Available Out of curiosity, how is data transferred now? Is it still xml? jon - Original Message - From: Steve Drucker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 1:06 PM Subject: RE: Harpoon Release is Final Available It's gone...the Harpoon documentation details various best practices for transferring information from ColdFusion to Flash. Using WDDX at this time, regrettably, is NOT a best practice. Regards, Steve Drucker CEO Fig Leaf Software -Original
Not very related - search engines
Have any of you got an idea about where i can submit my url to search engines. I need a place that will work. Plus i wanted to know, if i wanted each keyword to go to a certain page in the site not just to the homepage, is that possible? Or would that mean a separate submission for each page?! Thanks! Heidi = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
I dont suppose anyone had the beta .zip file anywhere ? I'd like to have a look at the datagrid that they left out ! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using WDDX for next 'n' style browsing
Dick Thanks for your advice, its funny but my boss just said the same thing (about using flash) My main goal was to not make another trip to the server (hence the use of javascript and wddx) Only the neccesary fields would be sent to the browser. I suggested using an applet but my boss pointed out without a java enabled browser with the correct version this functionality would be useless,I would have thought the same went for using flash as well. The two goals i was aiming for were not to perform another query and not to make another trip to the server. Is this possible with a cached query and Flash? Thanks KOla -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 16:43 To: CF-Talk Subject: Re: using WDDX for next 'n' style browsing I waited a while before weighing in on this, but here goes... rant I hate to see this type of design, where large amounts of data (most of it, probably, unneeded) are schlepped back and forth along the highway we call the internet. It clogs the net with [largely] unnecessary traffic. Further, the verbosity of WDDX packets only exacerbates the problem by increasing the amount of the data sent (over and over and over...) Look at a WDDX Packet and you will see it's size is many times larger than the actual data content. Don't get me wrong, I use WDDX every day, and used properly it is a valuable tool... But, WDDX is not meant to be an extension of the client/server system bus. /rant Use CF to cache your queries at the server in your CF program select only the required rows, and send them to the client If you want to improve this more, write a Flash front end for the client so that only the field names and data need to be sent to the client (eliminates retransmitting the entire HTML document) I think you will experience an overall performance improvement and better use of the server, internet connection, and the client... . kind of an *environmentally-friendly* program design! And, the user experience will be much improved too. Dick At 11:52 AM +0100 5/8/01, Kola Oyedeji wrote: I am passing a query object which consists of 1000 records in a hidden form field between pages as a WDDX packet, are there any reasons why this is a bad idea, such as limits to the amount of data which can be held in a form field or passed in a form? The reason for this is to save a trip to the server for each page of result. Are there any better solutions, would cacheing the query and executing it again for every page be more efficient than trying to offload the processing onto the client's machine? Thanks Kola ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: best search
OK - verity searches *best* on text files - and I gather you will be
creating a collection of text files - but you have to consider the display
of the content (i.e. to send the searcher to the correct page with the
correct formatting) - what we have done historically is this five stage
process:
1) create a verity collection in the server administrator
2) write a local indexing page that takes the collection and compiles it
with the correct url/ path functions. (in this case we usually have our
website road mad in mind - with section1.cfm text files in section1 folder,
section2.cfm text files in section2 folder, etc.)
3) create a search assist table with the following variables in:
a) id - unique ref
b) front - any front path you may need (e.g.
section1/section1.cfm?var=1 would be held as section1/ here)
c) middle - the search/clipped variable - used for cross checking
with verity url results - (e.g. section1/section1.cfm?var=1 would be
section1 here
d) end - any end variables or includes you may need for that page
(e.g. section1/section1.cfm?var=1 would be .cfm?var=1 here)
e) title - title of page to show in result output
4) write a search/results page which takes the search query and passes it
through the verity collection - to bring back the #url# variable - strips
the last 4 characters and everything before the last / which gives you a
clipped variable - then select content from the search assist table which
holds the clipped variable in the middle column - output this result (using
the full #front##middle##end# as the path)
5) write a cfschedule that re-indexes the collection at 2am (usual down time
for server)
This above methodology allows you to (for example) use JavaScript pop-up in
your output (e.g.
href=javascript:(displayPopUp('section1/section1.htm',400,600) where front
var = javascript:(displayPopUp('section1/, middle var = section1 and end
var = .htm',400,600), etc. - it's by no means the fastest method - as you
have to query the verity collection AND then query the sql table (use
blockfactor=100 here though) - but it's the most comprehensive if you have a
complex structure to your website - as it allows for pre/and post variables
to be added to the result url path (which other searches won't allow).
We use a similar methodology on a collection/site of 40mb and the average
results page would come back within 1265 milliseconds (which is chuggy)
In answer to your other query - yes the AltaVista is a server based search.
HTH
J
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 18:53
To: CF-Talk
Subject: Re: best search
As a rule of thumb use the right tool for the job, don't just use a tool
because it is there.
This is probarbly the best sentence I've heard this week! (come to think of
it, it's only monday.. :)
I asked for help and got it, but actually more questions arises, I'll try to
describe them:
1. the content would be txt and pure ASCII text only! actually I just
finished the mechanisem
which takes the html files from all of the sites I want to search in and
then remove
all html tags/javascript codes and stuff.
2. how much is considered BIG in the lite version of verity? 100mb, 200mb
of content?
that's about the amount I have.
3. verity would be great for me to display the data more efficient along
with CF tags. I know
CF, I know verity is easy to use, but I know they MUST be slower then
Microsoft Solutions.
(BTW: IS THERE ANY DIFFRENCE?, MS Search =SQL Full text?)
what will be the best way to go if:
I want the search to be as fast as possible YET:
1. I need an easy way to get the results to good-looking HTML format.
2. and maybe an easy way to still incorporate CF tags.
my database design is as follows:
uID = url ID
uLINK = full url location (i.e http://www.cftalk.com/whatis/cf.html)
uCONTENT = txt content I fetched from the site earlier?
do I actually need to save this data in tables or can I just search directly
on the txt files?
And final note: you mentioned Altavista engine - do they offer server search
engines too?
Thanks alot guys!! you'll be the first to run the search queries on my
engine :)
Michael.
- Original Message -
From: James Maltby [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 14, 2001 6:15 PM
Subject: RE: best search
It really depends on how your content is being displayed - if it's
flat-file
then Verity is OK - if it's a combination of SQL and Verity then pass your
query through both database and verity, if it's all sql held then rely on
sql/verity collections (faster than plain sql requests), however database
searches will depend on how often the data is to be updated. A quick rule
we use for template based sites is verity index the flat file content,
then
build a link database with file names and page titles in which is used
to
display the url links to the content (your option 2).
However, saying the above the main
RE: Restarting CF from Web
You can set up a batch file stop/start function and call it via telnet - safer than the http version in 4 On NT the code is something like: @echo off echo stopping ColdFusion... net stop Cold Fusion Application Server echo restarting ColdFusion... net start Cold Fusion Application Server echo done. Save it in a .bat file in the WinNt folder and connect via telnet to execute it.. HTH J -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 16:31 To: CF-Talk Subject: Restarting CF from Web Hello! In CF 4.0 there was a nifty java app that allowed me to stop and restart CF from a web page, however it is no more in 4.5. I no longer have a copy of 4.0 and really need to get a copy of this. Does anyone have a resource to get this or an alternative that will do the same thing? Thanks! Tim Painter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: best search
My problem is that I'm already have 300mb of textual content. The Verity Connection to CF really rocks and can help significantly in design, but I don't think it can handle the amount of data. Are you familier with Microsoft Solutions for this? (i.e MSSQL Full Text Search?) As for your project, I don't see no reason why should you even connect to SQL every time to get the unique ID or anything else, why don't you use the KEY,CUSTOM1 and CUSTOM2 fields to better process (with minmial milliseconds costs and risk that the SQL would be down...) also, I don't see the real use in spliting the full address into 3 parts (can you please exaplain and give an example on why this is of use?) I use verity on another site (http://www.imvamp.com) without no need to go to the database. ofcourse, the data was exported to sql, but only to be arranged more efficiently into a Verity collection. In your case of 40mb, I would consider doing the same. Any help on MS SQL Full Text Search would be great!!! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does application tag need to be executed every time?
It's only going to execute if application.name is not defined. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 15:15 To: CF-Talk Subject: Does application tag need to be executed every time? I have this code in my application tag: cfif NOT isDefined(application.name) cfapplication name=myapp sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# cfset application.name=myapp /cfif All the session/application vars seem to be fine Does the application tag have to be executed on every page request? If so why? Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Code Snippet:Random Password Generator(repost)
You could always run the output through a bad word filter and regen a password if there's a match (against the bad word list). But the rude words are so much easier to remember, or is that not the point? Dan. This message is intended only for the use of the person(s) (the intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
2 simpl q's about locking
2 questions about locking: 1. Do I need to lock application.engines whenever I try to isDefined() it or is this enugh: CFIF IsDefined(appliaction.engines) CFLOCK cfoutput#application.engines#/cfoutput /CFLOCK /CFIF 2. The Timeout Value - does it represent the MAXIMUM time (in seconds) that the var would be locked or does it represent the ACTUAL time that the variable would be lock (no matter if the process has ended succesfuly before the timeout)?? Thanks!! -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does application tag need to be executed every time?
Right, which means after the first execution there is no call to the application tag I thought that this would mean that none of my session vars or application vars would work as the application tag has not been called in this page request but they seem to be fine? KOLa -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:08 To: CF-Talk Subject: RE: Does application tag need to be executed every time? It's only going to execute if application.name is not defined. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 15:15 To: CF-Talk Subject: Does application tag need to be executed every time? I have this code in my application tag: cfif NOT isDefined(application.name) cfapplication name=myapp sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# cfset application.name=myapp /cfif All the session/application vars seem to be fine Does the application tag have to be executed on every page request? If so why? Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2 simpl q's about locking
The timeout value repressents how long the process will wait to obtain a lock of the type specified. If throwontimeout is set to Yes it will raise an exception if a lock can not be obtained, if it's No then the code will skip to the end of the block (not executing anything in the block). Eg. 1) session.foo is exclusively locked on Page1 and is being written to for 10 seconds 2) session.foo is called on Page2 w/ a 3 second timeout only 1 second after Page1 starts 3) Page2's lock times out and raises an exception (read: error) b/c default is to throw on timeout. 4) Page1 finishes execution and releases the lock -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: May 15, 2001 04:22 To: CF-Talk Subject: 2 simpl q's about locking 2 questions about locking: 1. Do I need to lock application.engines whenever I try to isDefined() it or is this enugh: CFIF IsDefined(appliaction.engines) CFLOCK cfoutput#application.engines#/cfoutput /CFLOCK /CFIF 2. The Timeout Value - does it represent the MAXIMUM time (in seconds) that the var would be locked or does it represent the ACTUAL time that the variable would be lock (no matter if the process has ended succesfuly before the timeout)?? Thanks!! -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help!! Problems???
Not quite sure of the problem. Would you not expect mutiple records. Your where clause doesn't look like a unique identifier. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 04:14 To: CF-Talk Subject: RE: Query Help!! Problems??? are shipfrom and shipto string? if so, you'll get that error on the second query, as you're comparing strings to numbers. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:16 PM To: CF-Talk Subject: RE: Query Help!! Problems??? OK when I use: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where '#total#' =shipfrom and '#total#' = shipto /cfquery I get multiple records returned. When I get rid of the tick marks: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where #total# =shipfrom and #total# = shipto /cfquery I get Data type mismatch in criteria expression. WHAT AM I DOING WRONG?? HELP, Rich -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:07 PM To: CF-Talk Subject: RE: Query Help!! These queries give me: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'shipRate' in query definition's SELECT list. Rich -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 5:35 PM To: CF-Talk Subject: RE: Query Help!! it's impossible to know what's wrong without knowing the values of the session variables at any given time You'll notice that you don't need to do a comparison on both numbers: cfquery name=myQuery... SELECT max(shipRate) AS shipRate FROM shipRatesDollars WHERE shipFrom = #val(session.total)# OR SELECT min(shipRate) AS shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# Either of these will return the one value you need Also if you're sure the columns in the DB will always be sorted in ascending order then just do this: cfquery name=myQuery maxrows=1... SELECT shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# This time the first record in the DB where shipTo is greater than your session variable is the one you want and will be the only one returned. You may have noticed by now that you only need to have shipFrom OR shipTo in the DB table, you do not need both :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:01 PM To: CF-Talk Subject: Query Help!! Does anyone see any problems with the following query: cfquery name=get_shipratedollars datasource=#config.datasource# Select shiprate from shipratesdollars WHERE '#session.total#' = shipfrom and '#session.total#' = shipto /cfquery I can not figure out why I am getting incorrect results. Sometimes it will pull more than one record and sometimes it will pull the max record only. Here is a copy of the table I am using named shipratedollars. ID shiprateshipfrom shipto 1 4.00 0.00 50.00 2 6.0050.01100.00 3 8.00 100.01200.00 4 12.00 200.01300.00 5 18.00 300.01500.00 6 25.00 500.01750.00 7 40.00 750.01 1000.00 8 50.00 1000.01 1500.00 9 70.00 1500.01 2000.00 10 100.00 2000.009.00 Thansk, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help!! Problems???
What are you expecting to get? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:40 To: CF-Talk Subject: RE: Query Help!! Problems??? Not quite sure of the problem. Would you not expect mutiple records. Your where clause doesn't look like a unique identifier. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 04:14 To: CF-Talk Subject: RE: Query Help!! Problems??? are shipfrom and shipto string? if so, you'll get that error on the second query, as you're comparing strings to numbers. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:16 PM To: CF-Talk Subject: RE: Query Help!! Problems??? OK when I use: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where '#total#' =shipfrom and '#total#' = shipto /cfquery I get multiple records returned. When I get rid of the tick marks: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where #total# =shipfrom and #total# = shipto /cfquery I get Data type mismatch in criteria expression. WHAT AM I DOING WRONG?? HELP, Rich -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:07 PM To: CF-Talk Subject: RE: Query Help!! These queries give me: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'shipRate' in query definition's SELECT list. Rich -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 5:35 PM To: CF-Talk Subject: RE: Query Help!! it's impossible to know what's wrong without knowing the values of the session variables at any given time You'll notice that you don't need to do a comparison on both numbers: cfquery name=myQuery... SELECT max(shipRate) AS shipRate FROM shipRatesDollars WHERE shipFrom = #val(session.total)# OR SELECT min(shipRate) AS shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# Either of these will return the one value you need Also if you're sure the columns in the DB will always be sorted in ascending order then just do this: cfquery name=myQuery maxrows=1... SELECT shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# This time the first record in the DB where shipTo is greater than your session variable is the one you want and will be the only one returned. You may have noticed by now that you only need to have shipFrom OR shipTo in the DB table, you do not need both :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:01 PM To: CF-Talk Subject: Query Help!! Does anyone see any problems with the following query: cfquery name=get_shipratedollars datasource=#config.datasource# Select shiprate from shipratesdollars WHERE '#session.total#' = shipfrom and '#session.total#' = shipto /cfquery I can not figure out why I am getting incorrect results. Sometimes it will pull more than one record and sometimes it will pull the max record only. Here is a copy of the table I am using named shipratedollars. ID shiprateshipfrom shipto 1 4.00 0.00 50.00 2 6.0050.01100.00 3 8.00 100.01200.00 4 12.00 200.01300.00 5 18.00 300.01500.00 6 25.00 500.01750.00 7 40.00 750.01 1000.00 8 50.00 1000.01 1500.00 9 70.00
RE: Query Help!! Problems???
-- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:40 To: CF-Talk Subject: RE: Query Help!! Problems??? Not quite sure of the problem. Would you not expect mutiple records. Your where clause doesn't look like a unique identifier. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 04:14 To: CF-Talk Subject: RE: Query Help!! Problems??? are shipfrom and shipto string? if so, you'll get that error on the second query, as you're comparing strings to numbers. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:16 PM To: CF-Talk Subject: RE: Query Help!! Problems??? OK when I use: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where '#total#' =shipfrom and '#total#' = shipto /cfquery I get multiple records returned. When I get rid of the tick marks: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where #total# =shipfrom and #total# = shipto /cfquery I get Data type mismatch in criteria expression. WHAT AM I DOING WRONG?? HELP, Rich -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:07 PM To: CF-Talk Subject: RE: Query Help!! These queries give me: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'shipRate' in query definition's SELECT list. Rich -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 5:35 PM To: CF-Talk Subject: RE: Query Help!! it's impossible to know what's wrong without knowing the values of the session variables at any given time You'll notice that you don't need to do a comparison on both numbers: cfquery name=myQuery... SELECT max(shipRate) AS shipRate FROM shipRatesDollars WHERE shipFrom = #val(session.total)# OR SELECT min(shipRate) AS shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# Either of these will return the one value you need Also if you're sure the columns in the DB will always be sorted in ascending order then just do this: cfquery name=myQuery maxrows=1... SELECT shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# This time the first record in the DB where shipTo is greater than your session variable is the one you want and will be the only one returned. You may have noticed by now that you only need to have shipFrom OR shipTo in the DB table, you do not need both :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:01 PM To: CF-Talk Subject: Query Help!! Does anyone see any problems with the following query: cfquery name=get_shipratedollars datasource=#config.datasource# Select shiprate from shipratesdollars WHERE '#session.total#' = shipfrom and '#session.total#' = shipto /cfquery I can not figure out why I am getting incorrect results. Sometimes it will pull more than one record and sometimes it will pull the max record only. Here is a copy of the table I am using named shipratedollars. ID shiprateshipfrom shipto 1 4.00 0.00 50.00 2 6.0050.01100.00 3 8.00 100.01200.00 4 12.00 200.01300.00 5 18.00 300.01500.00 6 25.00 500.01750.00 7 40.00 750.01 1000.00 8 50.00 1000.01 1500.00 9 70.00 1500.01 2000.00 10
well that's a task!!!
I got this assignment recently: I need to create a thumbnail view of the front/home page of a given site. that should be done automaticlly, ofcourse. for example: I run this: CF_THUMBSITE site=http://www.imvamp.com; somehow I need to grab all of the site content and PICTURE IT as it were on a browser. this gots you thinking, ha? I know http://www.girafa.com does it, you can look into there for ideas. if anyone can solve this, I'm hearing! :) Thanks, -=Michael Lugassy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does application tag need to be executed every time?
the application tag enables session variables while the application is running. That only needs to be set once. Then session variables can eb set and maintained by cf. Application variabls will last the lifetime of the application anyway. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:26 To: CF-Talk Subject: RE: Does application tag need to be executed every time? Right, which means after the first execution there is no call to the application tag I thought that this would mean that none of my session vars or application vars would work as the application tag has not been called in this page request but they seem to be fine? KOLa -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:08 To: CF-Talk Subject: RE: Does application tag need to be executed every time? It's only going to execute if application.name is not defined. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 15:15 To: CF-Talk Subject: Does application tag need to be executed every time? I have this code in my application tag: cfif NOT isDefined(application.name) cfapplication name=myapp sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# cfset application.name=myapp /cfif All the session/application vars seem to be fine Does the application tag have to be executed on every page request? If so why? Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: catalog.wci filling up hard drive space?
Yes, that is the index for the index server. It's been a while, but I believe the space that it takes up is roughly 40-50% of the amount of space taken up by what it is indexing. If you are running newsgroups on the same server and indexing those, it can skyrocket. You can go into IIS and look up each directory and on the Home Directory tab, uncheck the Index this resource box. Tim P. - Original Message - From: Rick Lamb [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 2:58 PM Subject: OT: catalog.wci filling up hard drive space? We have a server that is filling up hard disk space very quickly and most of the growth is happening in this catalog.wci folder. Is this the logging folder for index server? If not what is it used for and how can I control it's growth? Thanks, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: best search
Sure - for v. big sites I have used AltaVista (www.dfee.gov.uk for example) and this is coolio - if I was to do it again though I would probably use Atomz.com stuff - for various reasons. Rationale for splitting full address into 3 parts: 1) Holding one url field means that you may as well use the default verity url param - but this does not allow for the inclusion of template page build variables. 2) Split the url into file name and variable includes means that if you have variable includes on a template you can include them (e.g. you have everything in you site coming through index.cfm with a menu variable and a content variable) - so index.cfm would default to the base menu and content, while links from this page would include alternate menus and content - e.g. index.cfm?menu=searchcontent=sitemap would use the base template, pull in the search menu (with relative sub-section options) and the sitemap content (check out www.connexionscard.gov.uk for an example of this) 3) there are some cases however when you may need a pre-variable (such as the javascript example I gave earlier - hence the 3 way split We are familiar with MSSQL Full Text Search, but it did not rock our world Key, custom1, etc is fine, but the pages/text content do not hold the relative include variables we need when building a nested template site (see above break-down). sorry I can't be of more help though J -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:59 To: CF-Talk Subject: Re: best search My problem is that I'm already have 300mb of textual content. The Verity Connection to CF really rocks and can help significantly in design, but I don't think it can handle the amount of data. Are you familier with Microsoft Solutions for this? (i.e MSSQL Full Text Search?) As for your project, I don't see no reason why should you even connect to SQL every time to get the unique ID or anything else, why don't you use the KEY,CUSTOM1 and CUSTOM2 fields to better process (with minmial milliseconds costs and risk that the SQL would be down...) also, I don't see the real use in spliting the full address into 3 parts (can you please exaplain and give an example on why this is of use?) I use verity on another site (http://www.imvamp.com) without no need to go to the database. ofcourse, the data was exported to sql, but only to be arranged more efficiently into a Verity collection. In your case of 40mb, I would consider doing the same. Any help on MS SQL Full Text Search would be great!!! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2 simpl q's about locking
Got it! and what about the isDefined(question) ? do you know the answer to it? Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does application tag need to be executed every time?
will I need to lock the isDefined(application.name) code for application.name. I mean - should I lock the code just to check for var existence via isDefined? I know the rest of the code should be locked! Thanks, Michael Lugassy - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 12:53 PM Subject: RE: Does application tag need to be executed every time? the application tag enables session variables while the application is running. That only needs to be set once. Then session variables can eb set and maintained by cf. Application variabls will last the lifetime of the application anyway. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:26 To: CF-Talk Subject: RE: Does application tag need to be executed every time? Right, which means after the first execution there is no call to the application tag I thought that this would mean that none of my session vars or application vars would work as the application tag has not been called in this page request but they seem to be fine? KOLa -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 11:08 To: CF-Talk Subject: RE: Does application tag need to be executed every time? It's only going to execute if application.name is not defined. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 15:15 To: CF-Talk Subject: Does application tag need to be executed every time? I have this code in my application tag: cfif NOT isDefined(application.name) cfapplication name=myapp sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# cfset application.name=myapp /cfif All the session/application vars seem to be fine Does the application tag have to be executed on every page request? If so why? Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2 simpl q's about locking
Sorry, it's late and I had completely forgetten about 1 by the time I finished reading 2.. hehe. I'm going to go a bit out on a limb here and say no. As you're only checking the symbol table to see if the name is defined -- not trying to get a coherent value from it or access the same memory address from possibly multiple simultaneous threads -- it should be thread safe. I personally don't lock on isDefined() checks but I may err in that practice (nor IIRC have I ever seen it mentioned in articles). If someone has more information on exactly how isDefined() works internally in regards to multi-threading it would be interesting to know. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: May 15, 2001 05:02 To: CF-Talk Subject: Re: 2 simpl q's about locking Got it! and what about the isDefined(question) ? do you know the answer to it? Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
I have one of them (Beta 2?), though not the most recent. My guess is that they gave up on the grid and the tree since they duplicated the now reworked CFFORM Java applets do to be released in ColdFusion 5. E-mail me off list if you want a copy of file. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 4:45 AM To: CF-Talk Subject: RE: Harpoon Release is Final Available I dont suppose anyone had the beta .zip file anywhere ? I'd like to have a look at the datagrid that they left out ! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Reworked CFFORM java applets ?
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] the now reworked CFFORM Java applets do to be released in ColdFusion 5. Does anyone have anymore details ? Specifcaly, does the new cfgrid provide the ability to specify data types (date, number) and defaults for new rows ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Server 7 book(s) recommendation
My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: finding special characters in a list
What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 7 book(s) recommendation
I've found the ones produced by Wrox Press and Que are good. I hear Professional SQL Server 2000 Programming by Robert Viera is quite good although I haven't read it. There are plenty of beginning SQL server books which are more likely to cover the basic Transact/and ANSI SQL language but they will be far from a thorough reference. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 13:28 To: CF-Talk Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Server 7 book(s) recommendation
I bought Lan Times Guide to SQL, and it was a good book to get my feet wet. It doesn't get into anything SQL Server specific though, and sticks to the standards. I also got the black Using SQL Server 7 from Que. I was totally underwhelmed, stay away from it. I now have 2 of the SQL Server 2000 Complete Reference books from Osborne which are great but 2000 specific so they wont help you. I'm not much help, but more info never hurts... jon - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 8:28 AM Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and custom stylesheets
Hi Scott We did exactly the same thing - the trick seemed to be that the style.cfm page has to have a CFCONTENT tag in it, otherwise the browser just doesn't get it. By the way, we found that it killed performance by an incredible amount, so we switched to doing it by writing the stylesheet to a .css file (with CFFILE) once the selections had been made, and just putting link rel=StyleSheet TYPE=text/css HREF=#CSSFilename#.css into subsequent pages. This lowered CPU DB load by almost a third - i'd HIGHLY recommend you try it like this. Cheers Alistair Davidson Senior Web Developer Rocom New Media www.rocomx.net -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 18:27 To: CF-Talk Subject: CF and custom stylesheets Hey gang... I've kinda got this working, but would prefer to improve it a bit. I'm trying to modify an existing app, that uses stylesheets, to allow for customization of the colorsets... so that User #1 can choose the blue set, User #2 the green set, etc. Each set has a hex color code for each of the styles used, stored in the DB... so basically, user logs in, tap the DB for the colorcodes, make session vars out of each, reference said vars when executing the style code, voila - purdy colors. :) I can do this easily enough if I just include the style page (as a .cfm file) - but what I'd *really* like to do is be able to link to the stylesheet page, so that the styles themselves don't show up in the source, i.e. LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I've had some hassles trying to link the page like this... it doesn't seem to properly execute the CF code within. Anyone out there tried to do this same thing, and succeeded? Input would be most welcome. Thanks in advance- --Scott ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 7 book(s) recommendation
I'd recommend Inside Microsoft SQL Server 7.0 by Ron Soukup and Karen Delaney (Microsoft Press). It's fifty something quid, but it goes into a lot of detail on just about every aspect of SQL 7, T-SQL included. It's a right rivetin' read..almost as good as Fly Fishing by J.R. Hartley. Cheers Alistair Davidson Senior Web Developer Rocom New Media www.rocomx.net -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 13:28 To: CF-Talk Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFORM Bug !!
Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my method to POST !! I found this bug in CF 4.0 and 4.51. So, It is over versions bug !! any suggestions will be appreciated. Hamid Hossain Saudi Arabia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 7 book(s) recommendation
I have that Professional SQL Server 7 and think its quite a good book. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 13:54 To: CF-Talk Subject: RE: SQL Server 7 book(s) recommendation I've found the ones produced by Wrox Press and Que are good. I hear Professional SQL Server 2000 Programming by Robert Viera is quite good although I haven't read it. There are plenty of beginning SQL server books which are more likely to cover the basic Transact/and ANSI SQL language but they will be far from a thorough reference. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 13:28 To: CF-Talk Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 7 book(s) recommendation
Aidan, I'm afraid this is a negative one as well, but on the strength of Amazon ratings I bought a very expensive M$ Press book called something like SQL Server 7.0 Database Implementation Kit which did include a 3-month eval of the DBMS but was very superficial. The only use I've found for it is that my 3-year-old daughter (4 tomorrow now I come to think of it) keeps some treasured belongings inside the box cover. For MS-SQL reference purposes I use the Books Online, which really is excellent, and/or the M$ web site. I believe the O'Reilly SQL book does a good job of explaining different SQL dialects a lot of people here have recommnded Joe Celko's SQL for Smarties and also one by Ben in the past.. haven't looked at any of them though. Nick -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:52 PM To: CF-Talk Subject: Re: SQL Server 7 book(s) recommendation I bought Lan Times Guide to SQL, and it was a good book to get my feet wet. It doesn't get into anything SQL Server specific though, and sticks to the standards. I also got the black Using SQL Server 7 from Que. I was totally underwhelmed, stay away from it. I now have 2 of the SQL Server 2000 Complete Reference books from Osborne which are great but 2000 specific so they wont help you. I'm not much help, but more info never hurts... jon - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 8:28 AM Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFORM Bug !!
That is expected behavior. DC - Original Message - From: Hamid Hossain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 09:27 Subject: CFFORM Bug !! Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my method to POST !! I found this bug in CF 4.0 and 4.51. So, It is over versions bug !! any suggestions will be appreciated. Hamid Hossain Saudi Arabia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 7 book(s) recommendation
Personally, I think the M$ books are too vague (rendering them useless), and a waste of money. The best book I've come across (and has since been referred to as the bible) is Transact-SQL Programming from O'Reilly. It covers MS SQL 7 and certainly has more than just T-SQL. Kurt -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:28 AM To: CF-Talk Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFORM Bug !!
To further clarify: the FORM scope is only availble to CF if the method was POST. So it only makes sense that CFFORM uses the POST scope when it writes out the FORM block. DC - Original Message - From: David E. Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 09:38 Subject: Re: CFFORM Bug !! That is expected behavior. DC - Original Message - From: Hamid Hossain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 09:27 Subject: CFFORM Bug !! Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my method to POST !! I found this bug in CF 4.0 and 4.51. So, It is over versions bug !! any suggestions will be appreciated. Hamid Hossain Saudi Arabia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFORM Bug !!
it's not a bug. the docs SAY that cfform only takes post. Hamid Hossain [EMAIL PROTECTED] on 05/15/2001 08:27:32 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: CFFORM Bug !! Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my method to POST !! I found this bug in CF 4.0 and 4.51. So, It is over versions bug !! any suggestions will be appreciated. Hamid Hossain Saudi Arabia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ACP + M? What's it gonna be?
Hello cf-talk, In regards to certificaton, I would assume that it cannot be called MCP (Macromedia Certified Professional), will it still stay ACP (Allaire Certified Professional) ?? Critter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
hiding the path of an included file
I have this in one of my style sheets:
..mask {
cfoutputbehavior :
url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput
}
When this runs, it shows the path to the mask_js.htc file if someone views
source. I would like to hide this path, so that no one can download thit
file easily. Unfortunately, the behavior property only uses URLs, so I
can't specify an unreachable absolute path.
Any ideas?
Todd
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: finding special characters in a list
this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:42 AM To: CF-Talk Subject: RE: finding special characters in a list What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: hiding the path of an included file
I have this in one of my style sheets:
..mask {
cfoutputbehavior :
url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput
}
When this runs, it shows the path to the mask_js.htc file if
someone views source. I would like to hide this path, so that
no one can download thit file easily. Unfortunately, the behavior
property only uses URLs, so I can't specify an unreachable absolute
path.
If you want people to be able to download it, you'll have to specify a URL,
and if someone wants to tinker around enough, there's nothing you can do to
prevent them from downloading the file itself. You could make it slightly
more difficult by using JavaScript to build URLs on the client - a sort of
obfuscation - but that's about it.
Since you're using IE-specific stuff like HTC files, though, you might be
able to encode some of the logic using the MS script encoder. There's more
info on that at http://msdn.microsoft.com/scripting/.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: finding special characters in a list
* Team Allaire * It may be either a chr(13) or a chr(10). Look for each individually. this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:42 AM To: CF-Talk Subject: RE: finding special characters in a list What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: finding special characters in a list
You have them reversed. Try cfset errorText = Find(Chr(13) Chr(10), mylist). -Original Message- From: Stephenie Hamilton [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:28 AM To: CF-Talk Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:42 AM To: CF-Talk Subject: RE: finding special characters in a list What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: finding special characters in a list
CR is generally CHR(13)+CHR(10) in that order. DC - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 10:28 Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:42 AM To: CF-Talk Subject: RE: finding special characters in a list What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2 simpl q's about locking
I'm going to go a bit out on a limb here and say no. As you're only checking the symbol table to see if the name is defined -- not trying to get a coherent value from it or access the same memory address from possibly multiple simultaneous threads -- it should be thread safe. I personally don't lock on isDefined() checks but I may err in that practice (nor IIRC have I ever seen it mentioned in articles). If someone has more information on exactly how isDefined() works internally in regards to multi-threading it would be interesting to know. According to an email I received quite a while back from Sim Simeonov at Allaire - the guy who was, at the time, the lead developer of the CF engine, I believe - IsDefined reads of memory variables should be locked. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using MySQL with CF and Apache.
I and a couple other members of the Annapolis CF User Group WWW.ANCFUG.COM are investigating getting MySQL database server to work with Cold Fusion 4.5 and Apache Web Server on Win9x/ME/NT boxes. Like to collaborate with any others interested in same. We have CF, Apache and MySQL installed and working in a rudimentary manner and want/need to do more. Please reply off-line if you are interested. Thanks... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: finding special characters in a list
Yea... Off hand I dont know the code for the paragraph code. What you could do is with a bit of text where you know there is a paragraph char loop over it and use the ASC() command with it to output the ascii code to it... Then track down the paragraph cmd and use chr(). Ie CFSET sSomeText = whatever CFLOOP FROM=1 TO=#Len(sSomeText)# INDEX=idxChar CFOUTPUT #ASC(MID(sSomeText, idxChar, 1))#BR /CFOUTPUT /CFLOOP Then you should be able to work out the actual code to check for HTH Mike -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 15:28 To: CF-Talk Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:42 AM To: CF-Talk Subject: RE: finding special characters in a list What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFORM Bug !!
It's a feature, not a bug :) Bernd --- David E. Crawford [EMAIL PROTECTED] wrote: To further clarify: the FORM scope is only availble to CF if the method was POST. So it only makes sense that CFFORM uses the POST scope when it writes out the FORM block. DC - Original Message - From: David E. Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 09:38 Subject: Re: CFFORM Bug !! That is expected behavior. DC - Original Message - From: Hamid Hossain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 09:27 Subject: CFFORM Bug !! Hi, I tried to use CFForm with GET as a method but when I ran the cfm I found that CF server changed my method to POST !! I found this bug in CF 4.0 and 4.51. So, It is over versions bug !! any suggestions will be appreciated. Hamid Hossain Saudi Arabia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
Dave, Can you point me to any documentation/info from Macromedia or Figleaf which shows this? I'm going to be starting a project with one of our Flash developers who's excited about the concept of using XML, but if it doesn't perform as well... But I'd like to have something with which to back up my claims. Thanks, Evan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:55 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available Using WDDX at this time, regrettably, is NOT a best practice. Is this because of some problem with Flash? Yes. The current version of Flash doesn't handle XML as efficiently as raw string data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
#cgi.HTTP_IF_MODIFIED_SINCE#
how can i use the variable #cgi.HTTP_IF_MODIFIED_SINCE# with IIS 5? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL
I'm using CFMAIL to send emails to a list of names in a database. Everything works fine, except for the fact that CF only releases about 100 emails at a time to our mail server. Our mail server is capable of sending many more, so it gets the hundred emails from CF and sends them out in a second, and then sits idle for about a minute until CF releases another 100. Is there a setting anywhere that causes CF to wait between batches of emails? I couldn't find any reference to it anywhere. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: @@identidy in sql server 7
Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Load me up
Anyone used RadView? What do you think? Else anyone suggest a good CF compatible server load testing app? TIA J The Force is strong in this one... - Darth Vader ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL
I found the Spool Interval setting since this post, but it seems the minimum is still 15 seconds. What I'd really like to see is if there is a way to get it to send more than 100 at a time. tom tom muck [EMAIL PROTECTED] wrote in message 3b014caa$[EMAIL PROTECTED]">news:3b014caa$[EMAIL PROTECTED]... I'm using CFMAIL to send emails to a list of names in a database. Everything works fine, except for the fact that CF only releases about 100 emails at a time to our mail server. Our mail server is capable of sending many more, so it gets the hundred emails from CF and sends them out in a second, and then sits idle for about a minute until CF releases another 100. Is there a setting anywhere that causes CF to wait between batches of emails? I couldn't find any reference to it anywhere. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
Well, here's some anecdotal evidence -- Once we removed XML as a transport mechanism and started relying on loadvariables, the average object shrank in byte-size by over 50% and load times, in one particular case (cascading menu), went from 8 seconds to under 2 seconds. Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:00 AM To: CF-Talk Subject: RE: Harpoon Release is Final Available Dave, Can you point me to any documentation/info from Macromedia or Figleaf which shows this? I'm going to be starting a project with one of our Flash developers who's excited about the concept of using XML, but if it doesn't perform as well... But I'd like to have something with which to back up my claims. Thanks, Evan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:55 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available Using WDDX at this time, regrettably, is NOT a best practice. Is this because of some problem with Flash? Yes. The current version of Flash doesn't handle XML as efficiently as raw string data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
grab links from a webpage
I have several hard coded link pages that I would like to grab all the links from and write to a database. I figured that if I did a cfhttp to the file and then did some sort of search on it, i could get the href and the link name and write it to the database. This isn't something that I have to do but I would like the experience. This is where i am so far. I can pull up the page using cfhttp. Now how do I search for links on it? Do i need to use find or refind? I don't fully understand reg expressions so I don't know how to use it that well. TIA Art ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Here's an idea ... hiding the path of an included file
Hey Todd, here's an idea .. .you could put that project down while you think
about it .. then while you're not working on it, you could help me get my
SITES BACK TOGETHER ... ITS BEEN NEARLY 2 WEEKS NOW SINCE YOU BROKE
EVERYTHING ... I STILL HAVE ONLY ONE SITE UP AGAIN AND I AM STILL UNABLE TO
CHECK ITS ALL WORKING. THE OTHER HAS JUST VANISHED.
HEY IVE BEEN ASKING FOR A WEEK . . . I NEED THE INFORMATION YOU PROMISED
TO GET MY SITES GOING AGAIN
How long would the rest of you tolerate your hosting company having your
site broken? 15 minutes? 30minutes? How about 2 weeks??And he
has time to work on developing pages while my fricken sites are down MY
GAWD!
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP Webworks
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 12:42 AM
To: CF-Talk
Subject: hiding the path of an included file
I have this in one of my style sheets:
..mask {
cfoutputbehavior :
url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput
}
When this runs, it shows the path to the mask_js.htc file if someone views
source. I would like to hide this path, so that no one can download thit
file easily. Unfortunately, the behavior property only uses URLs, so I
can't specify an unreachable absolute path.
Any ideas?
Todd
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: @@identidy in sql server 7
Depending on what you are doing... inside a stored procedure you can do this // Insert Into Table (ColumnList) Values(Values) Select @@Identity as NewID / HTH Clint -- Original Message -- From: Kola Oyedeji [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 15 May 2001 16:41:57 +0100 Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
CFQUERY name=whatever dsn=mydsn
SET NOCOUNT ON
INSERT INTO myTable (myVAL)
VALUES ('#form.val#');
SELECT @@IDENTITY AS NewID;
SET NOCOUNT OFF
/CFQUERY
This Assumes an Identity field in myTable...
CFOUTPUT query=whatever
#NewID#
/CFOUTPUT
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 8:42 AM
To: CF-Talk
Subject: OT: @@identidy in sql server 7
Can anyone please remind me how i get the value of a record
which was just inserted into a sql database. I know its called @@identidy.
I had a snippet but i cant find it,Thanks
KOla
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: finding special characters in a list
thanks michael, craig, david... got it working -- Stephenie -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:35 AM To: CF-Talk Subject: Re: finding special characters in a list CR is generally CHR(13)+CHR(10) in that order. DC - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 10:28 Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 8:42 AM To: CF-Talk Subject: RE: finding special characters in a list What you will probably have to do is use the Find() function in conjunction with the Chr() function. Ie to find a carriage return in some text you would Find(Chr(10) Chr(13), mystring) HTH -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 21:43 To: CF-Talk Subject: finding special characters in a list i am trying to parse through a list and pull out a block of text, the text i need ends with the paragraph symbol (when viewing special characters in CFStudio) anyone know how i can get cf list functions to recognize it? pardon the possibly stupid question, but is this the same as carriage return/line feed? -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Joins.
Hello folks, I ma having a spot of bother with joining tables in a query and could do with some advice. There are 4 tables: company_table, slow_stream, medium_stream and fast_stream Company table holds: company ID, name. The other tables also have a company_name field. I want to join all the tables together on the name field to give me one virtual table. What is the best way to go about this, I have tried in a number of ways. Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:42 AM To: CF-Talk Subject: OT: @@identidy in sql server 7 Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: Informix DB
Hi, We have a client who has a Informix database hosted on a unix server. We are working on a set of applications that will require us to tie into it via ColdFusion and Visual Basic. While I know ColdFusion has native support for Informix, we will need to setup ODBC for the other applications - does this require any changes on the server, or is it simply a matter of installing the client ODBC drivers? Thanks, Matt Fusfield Matthew I. Fusfield Web Development Manager InterActive Network Systems, Inc. [EMAIL PROTECTED] - 856-227-4428 ext 15 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
Is there any way to make the top level of the horizontal tool bar scroll? I can only fit 4 top level options, the second level will automatically scroll when there are more than the ammount of options that will fit on the screen. Rich -Original Message- From: Steve Drucker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 12:00 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available Well, here's some anecdotal evidence -- Once we removed XML as a transport mechanism and started relying on loadvariables, the average object shrank in byte-size by over 50% and load times, in one particular case (cascading menu), went from 8 seconds to under 2 seconds. Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:00 AM To: CF-Talk Subject: RE: Harpoon Release is Final Available Dave, Can you point me to any documentation/info from Macromedia or Figleaf which shows this? I'm going to be starting a project with one of our Flash developers who's excited about the concept of using XML, but if it doesn't perform as well... But I'd like to have something with which to back up my claims. Thanks, Evan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:55 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available Using WDDX at this time, regrettably, is NOT a best practice. Is this because of some problem with Flash? Yes. The current version of Flash doesn't handle XML as efficiently as raw string data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: finding special characters in a list
It should be chr(13) chr(10) and not the other way around. Not sure if that will work or not as I'm not sure what Studio flags as a paragraph but that is the proper sequence of CR and LF chars... HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 10:28 AM Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Joins.
I am guessing this is a one to many relationship between company_table and the remaining tables. select * from company_table t1 left outer join slow_stream t2 t1.name = t2.name left outer join medium_stream t2 on t1.name = t3.name left outer join fast_stream t4 on t1.name = t4.name However, you may encounter problems joining on text fields if the data type is char and not varchar or if the values have not been trimmed. In that case you would need to either add company_id to each of the tables or trim the name filed in the on statement. Hope this helps John -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:09 AM To: CF-Talk Subject: SQL Joins. Hello folks, I ma having a spot of bother with joining tables in a query and could do with some advice. There are 4 tables: company_table, slow_stream, medium_stream and fast_stream Company table holds: company ID, name. The other tables also have a company_name field. I want to join all the tables together on the name field to give me one virtual table. What is the best way to go about this, I have tried in a number of ways. Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
The other responses got it right but you probably want to either enclose both these statements in a transaction tag either on the sql side in a stored procedure or on the cold fusion side because someone could add another record to the table between your two statements and then you would get the wrong id. John -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:42 AM To: CF-Talk Subject: OT: @@identidy in sql server 7 Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Joins.
You could use INNER JOINs if each table has a company ID for sure. FROM company_table INNER JOIN slow_stream ON slow_stream.ID = company_table.ID INNER JOIN mesium_stream ON medium_stream.ID = company_table.ID INNER JOIN fast_stream ON fast_stream.ID = company_table.ID That should do it. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Losing - If at first you don't succeed, failure may be your style. ~despair.com -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 9:09 AM To: CF-Talk Subject: SQL Joins. Hello folks, I ma having a spot of bother with joining tables in a query and could do with some advice. There are 4 tables: company_table, slow_stream, medium_stream and fast_stream Company table holds: company ID, name. The other tables also have a company_name field. I want to join all the tables together on the name field to give me one virtual table. What is the best way to go about this, I have tried in a number of ways. Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
What does the set nocount on do? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
Diana, clint, Garza thanks Kola -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 17:07 To: CF-Talk Subject: RE: @@identidy in sql server 7 set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:42 AM To: CF-Talk Subject: OT: @@identidy in sql server 7 Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: grab links from a webpage
on 5/15/01 10:57 AM, Art Broussard at [EMAIL PROTECTED] wrote: I can pull up the page using cfhttp. Now how do I search for links on it? Do i need to use find or refind? I don't fully understand reg expressions so I don't know how to use it that well.go To learn more about regular expressions go to http://www.houseoffusion.com/ and download the PowerPoint presentation on regular expressions. Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Joins.
I think you need something along the lines of: Select fieldlist FROM company_table INNER JOIN slow_stream ON company_table.Name = slow_stream.company_name INNER JOIN medium_stream ON company_table.Name = medium_stream.company_name INNER JOIN fast_stream ON company_table.Name = fast_stream.company_name Note that that will only return records if there is a match between all 4 tables. if you want to return all records from the company_table, regardless of whether there is a match in the other tables, you'd use: Select fieldlist FROM company_table LEFT OUTER JOIN slow_stream ON company_table.Name = slow_stream.company_name LEFT OUTER JOIN medium_stream ON company_table.Name = medium_stream.company_name LEFT OUTER JOIN fast_stream ON company_table.Name = fast_stream.company_name HTH, Bob -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: May 15, 2001 12:09 PM To: CF-Talk Subject: SQL Joins. Hello folks, I ma having a spot of bother with joining tables in a query and could do with some advice. There are 4 tables: company_table, slow_stream, medium_stream and fast_stream Company table holds: company ID, name. The other tables also have a company_name field. I want to join all the tables together on the name field to give me one virtual table. What is the best way to go about this, I have tried in a number of ways. Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scientific Notation Formatting
Anyone have any ideas on how to format a number using scientific Notation? For example I have the number 2600 and I want to display 2.6e11 I would appreciate any help. Thanx * Corina S. Moore IMDC Software Developer 301-286-6124 http://imdc.nasa.gov ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: best search
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8828 best, paul At 12:58 PM 5/15/01 +0200, you wrote: Any help on MS SQL Full Text Search would be great!!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
Honestly, I'm not sure, but the @@identity won't work without it. I can't find it in the SQL docs, but pulled it from a message on this list at one point. D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 12:42 PM To: CF-Talk Subject: RE: @@identidy in sql server 7 What does the set nocount on do? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7 (What is SET NOCOUNT)
From the SQL Server BOL:
SET NOCOUNT
Stops the message indicating the number of rows affected by a Transact-SQL
statement from being returned as part of the results.
Syntax
SET NOCOUNT { ON | OFF }
Remarks
When SET NOCOUNT is ON, the count (indicating the number of rows affected by
a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the
count is returned.
The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.
SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client
for each statement in a stored procedure. When using the utilities provided
with Microsoft(r) SQL Server(tm) to execute queries, the results prevent nn
rows affected from being displayed at the end Transact-SQL statements such
as SELECT, INSERT, UPDATE, and DELETE.
For stored procedures that contain several statements that do not return
much actual data, this can provide a significant performance boost because
network traffic is greatly reduced.
The setting of SET NOCOUNT is set at execute or run time and not at parse
time.
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 9:42 AM
To: CF-Talk
Subject: RE: @@identidy in sql server 7
What does the set nocount on do?
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
set nocount on
insert into table ()
values ()
select @@identity as newID
set nocount off
HTH
D
*
Diana Nichols
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
no problem... feel free to ask me for help anytime... -- Original Message -- From: Kola Oyedeji [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 15 May 2001 17:49:05 +0100 Diana, clint, Garza thanks Kola -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 17:07 To: CF-Talk Subject: RE: @@identidy in sql server 7 set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:42 AM To: CF-Talk Subject: OT: @@identidy in sql server 7 Can anyone please remind me how i get the value of a record which was just inserted into a sql database. I know its called @@identidy. I had a snippet but i cant find it,Thanks KOla ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CSV file;CFFILE;Sybase IQ12
Hi all. Hoping someone who has BEEN THERE, DONE THAT can help. Have to create a csv file from a cfquery resultset which can then be imported into a number of programs that do statistical analysis. Approximately 5000 rows/records with a final size of 1730 kb. A sql count and the display of the first 10 rows to screen is only a matter of seconds. Using CFFILE to covert query to CSV was VERY SLOW (intranet: approx. 1 min/1000 rows). NOT ACCEPTIBLE. Downloading the file to the client machine is a matter of seconds (approx 1 sec/1000 rows). Using SQL and concatenating the fields per record, much, much faster. Easier, in SQL SYBASE IQ12 is to add the following after the last clause in the WHERE statement: ' newfile.txt'. The query WORKS in Interactive SQL, but when the SQL statement is wrapped in the CFQUERY, it BOMBS out. Can't read the as a piping command. SoThe question: what is the OPTIMAL process for generating the CSV file. Any and all help would be appreciated. Thanks, in advance, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
No. It's an inherent limitation. |-Original Message- |From: ibtoad [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:40 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Is there any way to make the top level of the horizontal tool |bar scroll? |I can only fit 4 top level options, the second level will automatically |scroll when there are more than the ammount of options that |will fit on the |screen. | |Rich | |-Original Message- |From: Steve Drucker [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:00 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Well, here's some anecdotal evidence -- | |Once we removed XML as a transport mechanism and started relying on |loadvariables, the average object shrank in byte-size by over |50% and load |times, in one particular case (cascading menu), went from 8 |seconds to under |2 seconds. | |Regards, |Steve Drucker |CEO |Fig Leaf Software | | |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 11:00 AM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Dave, | |Can you point me to any documentation/info from Macromedia or |Figleaf which |shows this? I'm going to be starting a project with one of our Flash |developers who's excited about the concept of using XML, but |if it doesn't |perform as well... | |But I'd like to have something with which to back up my claims. | |Thanks, | |Evan | | -Original Message- | From: Dave Watts [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 14, 2001 2:55 PM | To: CF-Talk | Subject: RE: Harpoon Release is Final Available | | | Using WDDX at this time, regrettably, is NOT a best practice. | | Is this because of some problem with Flash? | | Yes. The current version of Flash doesn't handle XML as |efficiently as raw | string data. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OpenIngres Database
Help! Does anyone know if there's a way to make an auto- incrementing number field in a CA OpenIngres database? Thanks! Norman Elton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identidy in sql server 7
SET NOCOUNT - determines if SQL returns the number of rows affected by the SQL command. So for an insert ... SQL would return a 1 (if successfully insert one row) or 0 (if the insert failed due to unique constraint or something) for the number of rows affected vice the SELECT @@identity. CFQUERY expects a single return set and drops the others ... first one back wins. Note that if the INSERT was wrapped in a stored procedure and you used cfstoredproc, you could return multiple result sets and in one have the number of rows affected and the @@identity value in another etc. Bill In a message dated Tue, 15 May 2001 1:21:17 PM Eastern Daylight Time, Mike Kear [EMAIL PROTECTED] writes: What does the set nocount on do? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] set nocount on insert into table () values () select @@identity as newID set nocount off HTH D * Diana Nichols ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: finding special characters in a list
Thats what I get for doin it off the top of my head... I dont usually need to worry about them both as if I am looking for a crlf then I set up vairable... But mainly its for formating pages and so I just look for the one i.e. Replace(sMyString, Chr(13), BR, ALL) -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 15:34 To: CF-Talk Subject: Re: finding special characters in a list It should be chr(13) chr(10) and not the other way around. Not sure if that will work or not as I'm not sure what Studio flags as a paragraph but that is the proper sequence of CR and LF chars... HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 10:28 AM Subject: RE: finding special characters in a list this doesn't seem to work, i need it to find the paragraph break, which seems to be different than a carriage return/line feed cfset errorText = Find(Chr(10) Chr(13), mylist) i have tried para;, no luck... -- Stephenie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Newbie - Help!!!!!
Hello, I have a large sql query I need to write and am having some problems with it. I have broken it down into several sections...the fist section I cannot figue out involves 3 table which I have listed below along with the main fields I need to deal with in parenthasis: tblContacts (pk_uniqueID, CMAppt) tblCasacCM (pk_CMAppt, pk_CasacAppt) tblCasac (pk_CasacAppt, CasacDate) In the tblCasac, there are many pk_CasacAppt's that relate to only one CMAppt. I need to capture the most recent pk_CasacAppt(using CasacDate) for a particular CMAppt. Hope this all makes sense,,,any suggestions would be greatly appreciated... TIA, Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF-Notes database connection
I investigated the CF-Talk archives and found a very brief mention of this last December, but am wondering if anyone else has had any experience with getting data into or out of a Lotus Notes database. I downloaded Lotus' NotesSQL driver, installed it, created a DSN, and verified it in CF Administrator. Only problem is that after the verification, CF Server was dead. I had to stop and restart CF Server. I created a simple query, which gave a NotesSQL error message, and CF Server was dead again. After repeated trials, after every attempt to connect to the database (Personal Address Book on local machine), either through a cfquery or through CF Admin, CF Server dies. Has anyone else found a way to make this connection in a semi-reliable manner? Thanks, Loyd Campbell Website Manager Bank One International Group 1700 Pacific Ave., 21st Floor Mail Code TX1-2805 Dallas, TX 75201 [EMAIL PROTECTED] 214-290-2811 (office) 972-567-9082 (cell) Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scientific Notation Formatting
You can do something like: cfset num=26000 cfoutput#numberformat(num / 10^(len(num)-1),9.9)#e#evaluate(len(num)-1)#/cfoutput Just bear in mind that this works for numbers =1 HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Corina Moore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 1:03 PM Subject: Scientific Notation Formatting Anyone have any ideas on how to format a number using scientific Notation? For example I have the number 2600 and I want to display 2.6e11 I would appreciate any help. Thanx * Corina S. Moore IMDC Software Developer 301-286-6124 http://imdc.nasa.gov ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ot on mouseover
I need a good script so that when you do an onmouseover on a link it will display text about the link. Then when an onmouseout it disappears. Joshua TIpton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Certified Developers listing on Allaire
How long after one certifies does it take to get listed on Allaire's site? Thanks, Tim Bahlke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange problem (or still asleep)
Hello, i'm running the code below and i'm not getting the expected results.
i'm passing in a variable with the length of 5 so i would expect that the
errorString would not be appended, but in fact it is. The same thing happens
when i pass in a variable with the length of 9. I can't seem to figure out
why this is happening. Can anyone help? Sorry if this is way basic.
david
code:
script
}else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){
errorString = ListAppend(errorString, Please enter a valid
zipcode (too long/short), |);
errorFlags = ListAppend(errorFlags, zp, |);
/script
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
Why? Rich -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:35 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available No. It's an inherent limitation. |-Original Message- |From: ibtoad [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:40 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Is there any way to make the top level of the horizontal tool |bar scroll? |I can only fit 4 top level options, the second level will automatically |scroll when there are more than the ammount of options that |will fit on the |screen. | |Rich | |-Original Message- |From: Steve Drucker [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:00 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Well, here's some anecdotal evidence -- | |Once we removed XML as a transport mechanism and started relying on |loadvariables, the average object shrank in byte-size by over |50% and load |times, in one particular case (cascading menu), went from 8 |seconds to under |2 seconds. | |Regards, |Steve Drucker |CEO |Fig Leaf Software | | |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 11:00 AM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Dave, | |Can you point me to any documentation/info from Macromedia or |Figleaf which |shows this? I'm going to be starting a project with one of our Flash |developers who's excited about the concept of using XML, but |if it doesn't |perform as well... | |But I'd like to have something with which to back up my claims. | |Thanks, | |Evan | | -Original Message- | From: Dave Watts [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 14, 2001 2:55 PM | To: CF-Talk | Subject: RE: Harpoon Release is Final Available | | | Using WDDX at this time, regrettably, is NOT a best practice. | | Is this because of some problem with Flash? | | Yes. The current version of Flash doesn't handle XML as |efficiently as raw | string data. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOOP and multiple variables
I have a shopping cart system (part of the one that came with CF Server) and i would like to have users be able to order multiple items with different quantities. IE a user could order 4 red hammers, 2 blue hammers, and 5 green hammers in one click of the button. When they hit the submit button i get these Form variables. FORM.SKU = 12,34,23 FORM.QUANTITY = 1,3,2 Here is my existing code to add the items, but right now it is setup to add only one item at a time with one quantity. How can i loop over this code with the proper SKU, and Quanity for each part of the form variables list? If i use cfloop INDEX=loopingSKU LIST=#form.SKU# then all i can loop is the SKU, the Quantity does not loop. !--- If the item is already in the basket... --- CFIF ListFind(Session.StoreItems, Form.SKU) NEQ 0 !--- Find where in the basket it is --- CFSET ItemPosition = ListFind(Session.StoreItems, Form.SKU) !--- Find out how many of the item are already in the basket --- CFSET CurrentQuantity = ListGetAt(Session.StoreQuantities, ItemPosition) !--- Now we add one to what's already in there --- CFSET Session.StoreQuantities = ListSetAt(Session.StoreQuantities, ItemPosition, CurrentQuantity + Form.Quantity) !--- Otherwise, just add it to the basket --- CFELSE CFSET Session.StoreItems = ListAppend(Session.StoreItems, Form.SKU) CFSET Session.StoreQuantities = ListAppend(Session.StoreQuantities, Form.Quantity) /CFIF Any help would be appreciated. Hopefully i explained this without making it super confusing. Thanks, Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Harpoon Release is Final Available
Well, you could adjust the font size down to accommodate more options as well... -S -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:35 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available No. It's an inherent limitation. |-Original Message- |From: ibtoad [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:40 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Is there any way to make the top level of the horizontal tool |bar scroll? |I can only fit 4 top level options, the second level will automatically |scroll when there are more than the ammount of options that |will fit on the |screen. | |Rich | |-Original Message- |From: Steve Drucker [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 12:00 PM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Well, here's some anecdotal evidence -- | |Once we removed XML as a transport mechanism and started relying on |loadvariables, the average object shrank in byte-size by over |50% and load |times, in one particular case (cascading menu), went from 8 |seconds to under |2 seconds. | |Regards, |Steve Drucker |CEO |Fig Leaf Software | | |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, May 15, 2001 11:00 AM |To: CF-Talk |Subject: RE: Harpoon Release is Final Available | | |Dave, | |Can you point me to any documentation/info from Macromedia or |Figleaf which |shows this? I'm going to be starting a project with one of our Flash |developers who's excited about the concept of using XML, but |if it doesn't |perform as well... | |But I'd like to have something with which to back up my claims. | |Thanks, | |Evan | | -Original Message- | From: Dave Watts [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 14, 2001 2:55 PM | To: CF-Talk | Subject: RE: Harpoon Release is Final Available | | | Using WDDX at this time, regrettably, is NOT a best practice. | | Is this because of some problem with Flash? | | Yes. The current version of Flash doesn't handle XML as |efficiently as raw | string data. | | Dave Watts, CTO, Fig Leaf Software | http://www.figleaf.com/ | voice: (202) 797-5496 | fax: (202) 797-5444 | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4.5/5.0 ORACLE stored procedures - how to cache results??
Folks, A key aspect of our site is a search function that allows users to specify criteria in several categories for a DSS-type query against the database. Since use of this feature is expected to be heavy, response time is critical. To optimize performance, we've designed this section to dynamically generate the SQL based on the user's selection. By dynamically generating the SQL, we can eliminate unneeded joins and tailor the criteria for faster throughput. To further improvement performance, we've designed the module that generates the SQL as an Oracle stored procedure that is called from the search page within a CFSTOREDPROC tag. To return multiple rows back to ColdFusion, we use an Oracle REF CURSOR from the stored procedure. While the stored procedure call from the CFSTOREDPROC tag works, we need the ability to cache large result sets (to allow paging through results) in the same way that the CFQUERY tag provides caching through the CACHEWITHIN option. we have tried the following two options unsuccessfully: (1) Add the CACHEWITHIN option to the CFSTOREDPROC tag (apparently not supported) (2) Call the stored procedure from within the CFQUERY tag - (REF CURSORS not supported) What are the options in achieving this functionality? Our platform is CF 4.5.1 (SP2) on Solaris against ORACLE 8.1.7 (Solaris) utilizing native drivers, but we're in a position to move to CF5 since we'd like to test that with Spectra 1.5.1 Release Candidate anyway. Thanks in advance for any information. -Darren ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ot on mouseover
use the title attrib. not sure if it works in NN though a href= title=hellotext/a -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:06 PM To: CF-Talk Subject: ot on mouseover I need a good script so that when you do an onmouseover on a link it will display text about the link. Then when an onmouseout it disappears. Joshua TIpton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Strange problem (or still asleep)
Change your OR to AND :)
Todd Ashworth --
Certified ColdFusion Developer
Network Administrator
Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: David Baskin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 2:20 PM
Subject: Strange problem (or still asleep)
| Hello, i'm running the code below and i'm not getting the expected
results.
| i'm passing in a variable with the length of 5 so i would expect that the
| errorString would not be appended, but in fact it is. The same thing
happens
| when i pass in a variable with the length of 9. I can't seem to figure out
| why this is happening. Can anyone help? Sorry if this is way basic.
|
| david
|
| code:
|
| script
|
| }else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){
| errorString = ListAppend(errorString, Please enter a valid
| zipcode (too long/short), |);
| errorFlags = ListAppend(errorFlags, zp, |);
|
| /script
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV file;CFFILE;Sybase IQ12
Wrap your CFOUTPUT Query in a CFHEADER tag: CFHEADER NAME=Content-Disposition VALUE=inline; filename=test.csv CFCONTENT TYPE=application/unknown cfoutput query=rs #rs.column1#, #rs.column2##chr(10)#/cfoutput cfabort tom www.basic-ultradev.com Carol Bluestein [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all. Hoping someone who has BEEN THERE, DONE THAT can help. Have to create a csv file from a cfquery resultset which can then be imported into a number of programs that do statistical analysis. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
E-commerce Dilemma
Hi! I need to implement an e-commerce package for one of my sites, but I haven't worked with e-commerce before. What they want is fairly simple, just the ability to buy items on-line. This in mind, I think AbleCommerce would be over-kill. The two I have researched are CFWebstore and Cartease. I'm torn between the two...does anyone have reasons to go with one or the other? What I need is a solution that I can add on to an existing site or build a complete store from scratch. Ease of implementation would be nice too :) Thanks, Christine ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Newbie - Help!!!!!
I think this will give you what you want. select top 1 t2.pk_CasacAppt from tblCasacCM left outer join tblCasac t2 on t1.pk_CasacAppt = t2.pk_CasacAppt left outer join tblContacts t3 on t1.pk_CMAppt = t3.CMAppt where pk_uniqueID = #Variable# order by t2.CasacDate desc John Hancock -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:01 PM To: CF-Talk Subject: SQL Newbie - Help! Hello, I have a large sql query I need to write and am having some problems with it. I have broken it down into several sections...the fist section I cannot figue out involves 3 table which I have listed below along with the main fields I need to deal with in parenthasis: tblContacts (pk_uniqueID, CMAppt) tblCasacCM (pk_CMAppt, pk_CasacAppt) tblCasac (pk_CasacAppt, CasacDate) In the tblCasac, there are many pk_CasacAppt's that relate to only one CMAppt. I need to capture the most recent pk_CasacAppt(using CasacDate) for a particular CMAppt. Hope this all makes sense,,,any suggestions would be greatly appreciated... TIA, Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: open link in new, maximized window?
I need a link to open up in a new maximized browser window. I figure its a windows setting issue instead of a code issue, correct? This is for a demonstration later today. My CF app is launching the GIS application and its opening the GIS App in a small window and its having trouble re-rendering when we maximize the window manually. Where do I change that setting so the browser window will open up maximized all the time? Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange problem (or still asleep)
Not sure but trim the variable to make sure it's not carrying the spaces.
John
-Original Message-
From: David Baskin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:20 PM
To: CF-Talk
Subject: Strange problem (or still asleep)
Hello, i'm running the code below and i'm not getting the expected results.
i'm passing in a variable with the length of 5 so i would expect that the
errorString would not be appended, but in fact it is. The same thing happens
when i pass in a variable with the length of 9. I can't seem to figure out
why this is happening. Can anyone help? Sorry if this is way basic.
david
code:
script
.
}else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){
errorString = ListAppend(errorString, Please enter a valid
zipcode (too long/short), |);
errorFlags = ListAppend(errorFlags, zp, |);
.
/script
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
