RE: using WDDX for next 'n' style browsing
Craig I'm just wondering what happens when 1000 users are executing searches at the same time, thats a thousand session variables with a 1000 records each. But it seems that setting the timeout may help. Thanks for the suggestion. KOla -Original Message- From: Craig Bowes [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 21:58 To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing Yes, and that is something to consider. But say a recordset has about 1000 records. A 1000 records of text isn't that much memory. And you could set the timeout so the session variable dies after a short while thus freeing memory that way. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:44 AM To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing But wont that mean each query would be held in the server RAM? KOla -Original Message- From: Craig Bowes [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:15 To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing Another idea for saving query times for N next records is to store the query as a session variable and you don't even have to run that query file at all. cfset session.savedquery = queryname then you can do your cfoutput query=session.savedquery maxrows=#nrows# be sure to put cflock around your cfset when setting session vars. -Craig -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 5:53 AM To: CF-Talk Subject: using WDDX for next 'n' style browsing 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: COM CFLOOP error
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Critter Sent: 9. mai 2001 14:47 To: CF-Talk Subject: Re: COM CFLOOP error Hmmm.. That doesn't work either. I don't know if the problem lies in CF or the object itself Now my code is like this: cfobject action=create class=POP3svg.Mailer type=COM name=Mailer cfset Mailer.GetPopHeaders(1) cfloop collection=#Mailer# item=akey cfoutput #akey.MessageInfo# /cfoutput /cfloop Critter wrote: when you loop thru a structure or collection the item is your key field so try outputting #akey.messageInfo# -- Best regards, Critter --- Wednesday, May 09, 2001, 8:21:38 S2k, you wrote: PK Hi all :) PK Im trying to loop thru a object structure with no luck. PK Im using an object from Serverobjects called AspPop3, and everything PK works fine, except when i try to loop thru a variant that is returned from PK the object. PK The structure i'm trying to output is explained in the documentation from PK serverobjects: PK The MessageInfo property returns the header data that is received from a PK call PK to GetPopHeaders. After a call to GetPopHeaders, and if there are messages PK on the server, PK this property is a variant array of variant arrays that contains information PK about the messages PK on the server. PK Values returned are: PK intMessageID, strSubject, strDate, strFrom, strSender ,strTo, strReplyTo, PK intSize, strStatus. PK The error i get is this one: PK -- PK Loop error PK Error on Invoke for: /nCOM error 0x80020003. Member not found. PK PK My code is (something) like this: PK (And i've tried any combinations in the loop that i can PK think of, using different collection parameters like #mailer#, PK #mailer.mesageinfo# etc. PK cfobject action=create class=POP3svg.Mailer type=COM name=Mailer PK cfset Mailer.RemoteHost = attributes.server PK cfset Mailer.UserName = attributes.username PK cfset Mailer.PassWord = attributes.password PK cfset Mailer.MailDirectory = attributes.attachmentpath PK cfset Mailer.GetPopHeaders(1) PK cfloop collection=#Mailer# item=akey PK cfoutput PK #MessageInfo# PK /cfoutput PK /cfloop PK If anyone could help me out with this one, I would be very, very, very PK happy... PK regards PK Per PK ~~ 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: Session variable
At 11:25 PM 05/10/2001 -0500, you wrote: I am trying to debug a website that is using Session variables. The problem is I have one account that is not getting to log on to the website because the session variable that are sent to the DB are not in the DB. However, all the other accounts that are using this same website are allowed to log on to website using the same code. In my debugging I have discovered that when I log on using a good account, and then immediately use the back button on the browser and log on with the bad account I am able to get into the website. You are storing CFID and CFTOKEN variables in the database, and automatically logging users in based on that? If you log in with a good account, hit the back button... I bet the 'bad' account logs back in as the good account. Without knowing how you are implementing any of this, I'm not sure. You may want to make sure that you are logging out before logging back in. (I.E. deleting all session variables and the CFID and CFTOKEN cookies ) Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- If it's the thought that counts you can always count on me I think about you all the time ~~ 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: searching date ranges
try this: cfset firstdate=dateadd('d',-90,now()) then, in your query.. where facility = 'Atlanta' and rcvd_date #firstdate# and audit_date = NULL 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: Tim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:09 PM To: CF-Talk Subject: searching date ranges I have a database with fields called facility, rcvd_date and audit_date. I need to query the database for a user selected facility with a rcvd_date that is greater than 90 days old and the audit_date field is blank. For instance, the user selects Atlanta, and the query will return all records for Atlanta, where the rcvd_date is older than 90 days from the current date, and the audit_date field is blank. So, if a record for Atlanta has a rcvd_date of 05/01/2001, it would not be returned, but one with a date of 02/01/2001 would. I have the facility portion done, but can not figure out how to search the rcvd_date field to check the records with dates 90 days old or more. Any ideas? Tim ~~ 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: [Re: Native Drivers - Oracle80]
First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the service name is what you will put in the host string spot in CF Admin. -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 12:14 AM To: CF-Talk Subject: Re: [Re: Native Drivers - Oracle80] ... you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also Yes, I had Oracle 8 client software installed and have created a service name, ABC. On the CF Settings page: DSN: ABC Host String: 127.0.0.1:1521 ColdFusion Login: ABCowner/** I created ABCowner NT user account with Admin right. What else did I miss? Regards, Julia Phu Tom Davison [EMAIL PROTECTED] wrote: did you install the oracle 8 client software on the server? when you do you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 4:26 PM Subject: Native Drivers - Oracle80 Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Are the data soruces setting configured properly? --- I believed I did --- * Did you provide valid security information in the data source settings? --- Honestly, I'm not quite sure what it means. --- * For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Window NT Services Control Panel to change the account the ColdFusion Server service is using. --- Again, I believed I did what it said. --- On the Oracle house, I have one sid with 2 instances. I need a connection to instance2. I'm stumbled on this problem for two days and couldn't find any material or expertise of the failure. Your enlightenment is greatly appreciated. Salute, Julia Phu ~~ 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: COM CFLOOP error
According to the documentation, MessageInfo is not a string, it's an array, so #aKey.MessageInfo# won't work. Unfortunately I do not have that object on my machine, so I cannot experiment. -David On Friday, May 11, 2001 4:03 AM, Per Kleven [SMTP:[EMAIL PROTECTED]] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Critter Sent: 9. mai 2001 14:47 To: CF-Talk Subject: Re: COM CFLOOP error Hmmm.. That doesn't work either. I don't know if the problem lies in CF or the object itself Now my code is like this: cfobject action=create class=POP3svg.Mailer type=COM name=Mailer cfset Mailer.GetPopHeaders(1) cfloop collection=#Mailer# item=akey cfoutput #akey.MessageInfo# /cfoutput /cfloop Critter wrote: when you loop thru a structure or collection the item is your key field so try outputting #akey.messageInfo# -- Best regards, Critter --- Wednesday, May 09, 2001, 8:21:38 S2k, you wrote: PK Hi all :) PK Im trying to loop thru a object structure with no luck. PK Im using an object from Serverobjects called AspPop3, and everything PK works fine, except when i try to loop thru a variant that is returned from PK the object. PK The structure i'm trying to output is explained in the documentation from PK serverobjects: PK The MessageInfo property returns the header data that is received from a PK call PK to GetPopHeaders. After a call to GetPopHeaders, and if there are messages PK on the server, PK this property is a variant array of variant arrays that contains information PK about the messages PK on the server. PK Values returned are: PK intMessageID, strSubject, strDate, strFrom, strSender ,strTo, strReplyTo, PK intSize, strStatus. PK The error i get is this one: PK -- PK Loop error PK Error on Invoke for: /nCOM error 0x80020003. Member not found. PK PK My code is (something) like this: PK (And i've tried any combinations in the loop that i can PK think of, using different collection parameters like #mailer#, PK #mailer.mesageinfo# etc. PK cfobject action=create class=POP3svg.Mailer type=COM name=Mailer PK cfset Mailer.RemoteHost = attributes.server PK cfset Mailer.UserName = attributes.username PK cfset Mailer.PassWord = attributes.password PK cfset Mailer.MailDirectory = attributes.attachmentpath PK cfset Mailer.GetPopHeaders(1) PK cfloop collection=#Mailer# item=akey PK cfoutput PK #MessageInfo# PK /cfoutput PK /cfloop PK If anyone could help me out with this one, I would be very, very, very PK happy... PK regards PK Per ~~ 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: COM CFLOOP error
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Shadovitz Sent: 11. mai 2001 14:52 To: CF-Talk Subject: RE: COM CFLOOP error I know I've tried every combinations I can think of, but i just end up with: Error on Invoke for: /nCOM error 0x80020003. Member not found. - Per According to the documentation, MessageInfo is not a string, it's an array, so #aKey.MessageInfo# won't work. Unfortunately I do not have that object on my machine, so I cannot experiment. -David On Friday, May 11, 2001 4:03 AM, Per Kleven [SMTP:[EMAIL PROTECTED]] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Critter Sent: 9. mai 2001 14:47 To: CF-Talk Subject: Re: COM CFLOOP error Hmmm.. That doesn't work either. I don't know if the problem lies in CF or the object itself Now my code is like this: cfobject action=create class=POP3svg.Mailer type=COM name=Mailer cfset Mailer.GetPopHeaders(1) cfloop collection=#Mailer# item=akey cfoutput #akey.MessageInfo# /cfoutput /cfloop Critter wrote: when you loop thru a structure or collection the item is your key field so try outputting #akey.messageInfo# -- Best regards, Critter --- Wednesday, May 09, 2001, 8:21:38 S2k, you wrote: PK Hi all :) PK Im trying to loop thru a object structure with no luck. PK Im using an object from Serverobjects called AspPop3, and everything PK works fine, except when i try to loop thru a variant that is returned from PK the object. PK The structure i'm trying to output is explained in the documentation from PK serverobjects: PK The MessageInfo property returns the header data that is received from a PK call PK to GetPopHeaders. After a call to GetPopHeaders, and if there are messages PK on the server, PK this property is a variant array of variant arrays that contains information PK about the messages PK on the server. PK Values returned are: PK intMessageID, strSubject, strDate, strFrom, strSender ,strTo, strReplyTo, PK intSize, strStatus. PK The error i get is this one: PK -- PK Loop error PK Error on Invoke for: /nCOM error 0x80020003. Member not found. PK PK My code is (something) like this: PK (And i've tried any combinations in the loop that i can PK think of, using different collection parameters like #mailer#, PK #mailer.mesageinfo# etc. PK cfobject action=create class=POP3svg.Mailer type=COM name=Mailer PK cfset Mailer.RemoteHost = attributes.server PK cfset Mailer.UserName = attributes.username PK cfset Mailer.PassWord = attributes.password PK cfset Mailer.MailDirectory = attributes.attachmentpath PK cfset Mailer.GetPopHeaders(1) PK cfloop collection=#Mailer# item=akey PK cfoutput PK #MessageInfo# PK /cfoutput PK /cfloop PK If anyone could help me out with this one, I would be very, very, very PK happy... PK regards PK Per ~~ 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
Need help for using cfftp to access to MVS system
Hi, has anyone use cfftp to acess to MVS system? I am able to open a connection, but not able to list the directory. I can get the current directory, but for some reason when I try to list directory, I kept getting 0 record. here is my code cfftp action=OPEN server=mvs server username=XXX password=XXX stoponerror=Yes port=21 connection=mvs cfoutput Did you succeed? #cfftp.succeeded#br cfftp.errorcode:#cfftp.errorcode#br cfftp.errortext:#cfftp.errortext#br /cfoutput cfftp action=GETCURRENTDIR stoponerror=Yes connection=titan cfoutputcurrentdir:#cfftp.returnvalue#/cfoutputbr cfftp action=LISTDIR stoponerror=Yes name=getit directory=#cfftp.returnvalue# connection=mvs total files: cfoutput#getit.recordcount#/cfoutputbr |cfoutput query=getit #name#br /cfoutput| BR cfoutput Did you succeed? #cfftp.succeeded#br cfftp.errorcode:#cfftp.errorcode#br cfftp.errortext:#cfftp.errortext#br /cfoutput cfftp action=CLOSE stoponerror=Yes connection=mvs ~~ 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: Just in time compliation error
What would cause a Just in time compilation error? ~~ 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: URL Parameter in window.open
what about window.open('file.cfm?name='+value, ... ) as long it is a defined JS variable it should work... correct? Steve Darren Adams wrote: That should work fine but if you intend to send through CF variables then you need to wrap it in a CFOUTPUT. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 15:40 To: CF-Talk Subject: JS:URL Parameter in window.open does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) is there another easy way to control window size while passing a parameter in the URL??? TNX if you can help. Rick Colman ~~ 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
the dbl devil
Hi all, I'm using Access for my database. Sometimes when I need to make changes to the database on the server there is a .dbl file in the directory. I can't delete it, and it won't let me upload the database. A couple days ago someone on this list said to create a query calling a table that doesn't exist. I did that. Got the error on the screen, but the devilish dbl was still there. I talked to my cf host and he said, Your code is holding your database too long..put in your code a time to release the database after so many minutes. Does anyone know what he was talking about? Also, thanks for your assistance on my syntax error when inserting date. I was thrown off because cfinsert and cfupdate worked fine. But all went awry when I tried to use insert in a query in a cfloop. So changing the field name from date to classdate did the trick. Thanks! Megan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: structure in request scope
And to wrap it all up You want to write the query in a persistent scope. But since every time you write to or access a persistent scope you must lock the access, you want to copy the query to the request scope in the application.cfm. This way you will only nead to bother with the locking process when creating the query and copying to the request scope. Everywhere else in your site you'll call the request variable to access the query info... and you won't have to use a lock. so your application.cfm would look something like this. !--- Create the query in a persistent scope --- cflock scope=APPLICATION throwontimeout=No timeout=1 type=EXCLUSIVE cfif NOT isdefined(application.myquery) cfquery name=application.myquery datasource=mydsn [SQL Stuff] /cfquery /cfif /cflock !--- Copy the query to the request scope --- cflock scope=APPLICATION throwontimeout=No timeout=1 type=READONLY cfset request.myquery = duplicate(application.myquery) /cflock |-Original Message- |From: Sean Daniels [mailto:[EMAIL PROTECTED]] |Sent: Thursday, May 10, 2001 10:54 AM |To: CF-Talk |Subject: Re: structure in request scope | | |On 5/10/01 1:59 AM Mark Ireland wrote: | | Could someone tell me how to load a structure into the |request scope in the | application.cfm | | once only when a user first visits a page. That is, check that the | structure is there and dont rerun the query code if it is | | unless a change has been made to the database. | |It sounds like you want to put the structure into a persistent |scope, which |request is not. Use the application scope instead if it is |global to all |users. If not, client or session scope. | |cfif isdefined(application.strFoo) |cflock type=exclusive scope=application name=strLock |cfset application.strFoo = structnew() |!--- etc --- |/cflock |/cfif | | |- Sean | ~~ 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: Just in time compliation error
Syntax errors, poorly constructed code, etc. DC - Original Message - From: Lewis Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 09:10 Subject: OT: Just in time compliation error What would cause a Just in time compilation error? ~~ 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: URL Parameter in window.open
Yep should work. -Original Message- From: Lewis Steven [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 14:16 To: CF-Talk Subject: Re: URL Parameter in window.open what about window.open('file.cfm?name='+value, ... ) as long it is a defined JS variable it should work... correct? Steve Darren Adams wrote: That should work fine but if you intend to send through CF variables then you need to wrap it in a CFOUTPUT. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 15:40 To: CF-Talk Subject: JS:URL Parameter in window.open does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) is there another easy way to control window size while passing a parameter in the URL??? TNX if you can help. Rick Colman ~~ 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: the dbl devil
cfset CFUSION_DBCONNECTIONS_FLUSH() Connections Flushed. OR (CF 4.5 and later): CFSET rc=cfusion_disable_dbconnections(cfmysource,1) to disable a specific datasource. CFSET rc=cfusion_disable_dbconnections(cfmysource,0) will re-enable it. ~Simon Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:27 AM To: CF-Talk Subject: the dbl devil Hi all, I'm using Access for my database. Sometimes when I need to make changes to the database on the server there is a .dbl file in the directory. I can't delete it, and it won't let me upload the database. A couple days ago someone on this list said to create a query calling a table that doesn't exist. I did that. Got the error on the screen, but the devilish dbl was still there. I talked to my cf host and he said, Your code is holding your database too long..put in your code a time to release the database after so many minutes. Does anyone know what he was talking about? Also, thanks for your assistance on my syntax error when inserting date. I was thrown off because cfinsert and cfupdate worked fine. But all went awry when I tried to use insert in a query in a cfloop. So changing the field name from date to classdate did the trick. Thanks! Megan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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
Session Variables - I don't get it
Greetings, I'm not getting how to implement session variables. I'm just trying to set the session variable Session.Dog from black to Blue and have it show up as Blue on the test.cfm. It keep show'n up black. I do have Session Variables enabled via the CF Administrator page. What am I miss'n here. !--- Application.CFM --- cfapplication name=TEST sessionmanagement=Yes setclientcookies=no cflock scope=session timeout=2 cfset Session.Dog = Black /cflock !--- Test.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput cfset #Session.Dog# = Bluebr /cflock cflock scope=session type=readonly timeout=2 a href=test2.cfm?cfoutput#Session.URLTOKEN#/cfoutput Goto/abr /cflock /body /html !--- Test2.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput /cflock br /body /html - Can someone get me started here. Thanks Doug Kronenberger OI National Training and Education Office 440-526-3030 x7776 ~~ 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: the dbl devil
There is another way to get rid of the .ldb file so that you can upload your new database. Run this piece of code (where DSN has been changed to your dsn) CFSET rc=cfusion_disable_dbconnections(DSN,1) After that has run, run this piece of code (Again where DSN has been changed to your dsn name) CFSET rc=cfusion_disable_dbconnections(DSN,0) That should do it. It works great for me. Jon Scherdin Software Engineer Control Systems Integrators ~~ 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
CFQUERY max. timeout is 999,999,999 ms
I'll go ahead and answer my own question ... Looks like the CFQUERY max. timeout the driver will take is 999,999,999 milliseconds (timeout=9). [CF 4.5.1 SP2 on Solaris] I did a couple quick tests and learned: 1) ODBC drivers do not support the timeout attribute in CFQUERY 2) Native drivers support the timeout attribute up to 999,999,999 Any more than that and it errors with: Cannot convert 99 to integer. Please, check the ColdFusion manual for the allowed conversions between data types Chris Norloff P.S. 999,999,999 milliseconds is about 277 days ... so perhaps we CAN let those users print out their millions of lines :-) -- Original Message -- From: Chris Norloff [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 10 May 2001 11:41:39 -0400 Anybody know what the CFQUERY maximum timeout value is? It seems to be driver-dependent; we're running Oracle Native Drivers on CF 4.5. SP2. thanks, Chris Norloff from the online help: TIMEOUT Optional. Lets you specify a maximum number of milliseconds for the query to execute before returning an error indicating that the query has timed-out. This attribute is not supported by most ODBC drivers. TIMEOUT is supported by the SQL Server 6.x or above driver. The minimum and maximum allowable values vary, depending on the driver. ~~ 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: the dbl devil
Megan, Provided you are using CF4.5.x you should be able to use the cfusion_dbconnections_flush() function to release the database. You do need to make sure that from the time you release the connection to the time you delete the database or replace it that no database accesses are done, otherwise the database will again be locked. The use of 'date' as a field name is a pretty common mistake, it would be nice if Access provided warnings about this when you create a database but it does not. Chris -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:27 AM To: CF-Talk Subject: the dbl devil Hi all, I'm using Access for my database. Sometimes when I need to make changes to the database on the server there is a .dbl file in the directory. I can't delete it, and it won't let me upload the database. A couple days ago someone on this list said to create a query calling a table that doesn't exist. I did that. Got the error on the screen, but the devilish dbl was still there. I talked to my cf host and he said, Your code is holding your database too long..put in your code a time to release the database after so many minutes. Does anyone know what he was talking about? Also, thanks for your assistance on my syntax error when inserting date. I was thrown off because cfinsert and cfupdate worked fine. But all went awry when I tried to use insert in a query in a cfloop. So changing the field name from date to classdate did the trick. Thanks! Megan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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
ASPEncrypt ASPUpload
Have any of you guys used these objects in CF ?? ( www.aspencrypt.com www.aspupload.com ) - Per ~~ 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: structure in request scope
I find it easier and simpler to put the query in request scope in the first place (not really necessary) and cache it. That way, none of the below is necessary. best, paul At 09:27 AM 5/11/01 -0400, you wrote: And to wrap it all up You want to write the query in a persistent scope. But since every time you write to or access a persistent scope you must lock the access, you want to copy the query to the request scope in the application.cfm. This way you will only nead to bother with the locking process when creating the query and copying to the request scope. Everywhere else in your site you'll call the request variable to access the query info... and you won't have to use a lock. so your application.cfm would look something like this. !--- Create the query in a persistent scope --- cflock scope=APPLICATION throwontimeout=No timeout=1 type=EXCLUSIVE cfif NOT isdefined(application.myquery) cfquery name=application.myquery datasource=mydsn [SQL Stuff] /cfquery /cfif /cflock !--- Copy the query to the request scope --- cflock scope=APPLICATION throwontimeout=No timeout=1 type=READONLY cfset request.myquery = duplicate(application.myquery) /cflock |-Original Message- |From: Sean Daniels [mailto:[EMAIL PROTECTED]] |Sent: Thursday, May 10, 2001 10:54 AM |To: CF-Talk |Subject: Re: structure in request scope | | |On 5/10/01 1:59 AM Mark Ireland wrote: | | Could someone tell me how to load a structure into the |request scope in the | application.cfm | | once only when a user first visits a page. That is, check that the | structure is there and dont rerun the query code if it is | | unless a change has been made to the database. | |It sounds like you want to put the structure into a persistent |scope, which |request is not. Use the application scope instead if it is |global to all |users. If not, client or session scope. | |cfif isdefined(application.strFoo) |cflock type=exclusive scope=application name=strLock |cfset application.strFoo = structnew() |!--- etc --- |/cflock |/cfif | | |- Sean | ~~ 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: [Re: Native Drivers - Oracle80]
I am running into the same problem. I can connect to it via SqlPlus on the same machine and I have it running fine on another server. Any clues? Should I reinstall the oracle client? Thanks Tim P. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:13 AM Subject: Re: [Re: Native Drivers - Oracle80] ... you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also Yes, I had Oracle 8 client software installed and have created a service name, ABC. On the CF Settings page: DSN: ABC Host String: 127.0.0.1:1521 ColdFusion Login: ABCowner/** I created ABCowner NT user account with Admin right. What else did I miss? Regards, Julia Phu Tom Davison [EMAIL PROTECTED] wrote: did you install the oracle 8 client software on the server? when you do you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 4:26 PM Subject: Native Drivers - Oracle80 Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Are the data soruces setting configured properly? --- I believed I did --- * Did you provide valid security information in the data source settings? --- Honestly, I'm not quite sure what it means. --- * For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Window NT Services Control Panel to change the account the ColdFusion Server service is using. --- Again, I believed I did what it said. --- On the Oracle house, I have one sid with 2 instances. I need a connection to instance2. I'm stumbled on this problem for two days and couldn't find any material or expertise of the failure. Your enlightenment is greatly appreciated. Salute, Julia Phu ~~ 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 style sheets
I've done this successfully, but I don't think there's any advantage to it over putting a style block in a cfinclude. If fact I think the include is better -- why? 1. the advantage of the linked stylesheet is that it gets cached on the client the first time it's called and doesn't have to be downloaded again -- but I found that with a dynamic stylesheet, that was not the case -- the stylesheet was processed and downloaded on every request 2. if you have errors in the CFML, they will be difficult to debug, because they won't show up in CF debugging info if the cfm page is called through a link tag I tested this about year ago, on whatever version of CF was current then, so I can't say whether all this still holds true. Robert Robert Crooks Educational Services Technical Lead Macromedia, Inc -Original Message- From: Eric Gilbert [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 7:08 PM To: CF-Talk Subject: RE: CF and custom style sheets It's pretty a straight forward solution. 1) The code to call the included stylesheet could look something like this LINK REL=Style Sheet TYPE=text/css HREF=stylesheet.cfm regular old html3.2 except for .cfm so that the requested file gets parsed by cf 2) In stylesheet.cfm snip !--- just to keep things cleanish and debug free --- cfsetting enablecfoutputonly=No showdebugoutput=no !--- the real key here --- cfcontent type=text/css h1 { font-family: cfoutput#Session.stylesheet.H1.Font-Family#/cfoutput !--- the session stored style information *Remember To make sure the Session.stylesheet structure is defined before here* --- } /snip I used a session structure but you could just as easily use client vars or application vars. This is the non locked version obviously cf_shame onMe=YesI know, I know, shared scope variables need locking/cf_shame but this basic approach should work for you, unless I am totally off the mark as to what you need. The browser requests the file like any other file but it doesn't know that it is a stylesheet unless you use the cfcontent type=text/css. - Eric -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:37 AM To: CF-Talk Subject: Re: CF and custom style sheets On 5/10/01 1:27 PM Scott Weikert wrote: 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. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ 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: Session Variables - I don't get it
Have you got cookies switched on? incidentaly you dont need ## signs inside cfset. KOla -Original Message- From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 14:50 To: CF-Talk Subject: Session Variables - I don't get it Greetings, I'm not getting how to implement session variables. I'm just trying to set the session variable Session.Dog from black to Blue and have it show up as Blue on the test.cfm. It keep show'n up black. I do have Session Variables enabled via the CF Administrator page. What am I miss'n here. !--- Application.CFM --- cfapplication name=TEST sessionmanagement=Yes setclientcookies=no cflock scope=session timeout=2 cfset Session.Dog = Black /cflock !--- Test.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput cfset #Session.Dog# = Bluebr /cflock cflock scope=session type=readonly timeout=2 a href=test2.cfm?cfoutput#Session.URLTOKEN#/cfoutput Goto/abr /cflock /body /html !--- Test2.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput /cflock br /body /html - Can someone get me started here. Thanks Doug Kronenberger OI National Training and Education Office 440-526-3030 x7776 ~~ 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: Session Variables - I don't get it
Hi You're setting the session.dog variable to Black EACH time in your application file, and in your test.cfm file to Blue AFTER it's outputted. So when you output it, it's set to black. use cfparam name=session.dog default=black in the application.cfm file, and cfset session.dog = blue BEFORE cfoutput#session.dog#/cfoutput in the test.cfm file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kronenberger, Douglas Sent: 11. mai 2001 15:50 To: CF-Talk Subject: Session Variables - I don't get it Greetings, I'm not getting how to implement session variables. I'm just trying to set the session variable Session.Dog from black to Blue and have it show up as Blue on the test.cfm. It keep show'n up black. I do have Session Variables enabled via the CF Administrator page. What am I miss'n here. !--- Application.CFM --- cfapplication name=TEST sessionmanagement=Yes setclientcookies=no cflock scope=session timeout=2 cfset Session.Dog = Black /cflock !--- Test.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput cfset #Session.Dog# = Bluebr /cflock cflock scope=session type=readonly timeout=2 a href=test2.cfm?cfoutput#Session.URLTOKEN#/cfoutput Goto/abr /cflock /body /html !--- Test2.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput /cflock br /body /html - Can someone get me started here. Thanks Doug Kronenberger OI National Training and Education Office 440-526-3030 x7776 ~~ 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: the dbl devil
just keep in mind (as simon pointed out) this is specific to CF 4.5.x and later. -Original Message- From: Jon Scherdin [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 6:39 AM To: CF-Talk Subject: Re: the dbl devil There is another way to get rid of the .ldb file so that you can upload your new database. Run this piece of code (where DSN has been changed to your dsn) CFSET rc=cfusion_disable_dbconnections(DSN,1) After that has run, run this piece of code (Again where DSN has been changed to your dsn name) CFSET rc=cfusion_disable_dbconnections(DSN,0) That should do it. It works great for me. Jon Scherdin Software Engineer Control Systems Integrators ~~ 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: Session Variables - I don't get it
The application.cfm runs before every page and resets your variable session.dog. Just set the value of that session variable in your code somewhere other than the application.cfm and it should work. I hope this helps. -Original Message- From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:50 AM To: CF-Talk Subject: Session Variables - I don't get it Greetings, I'm not getting how to implement session variables. I'm just trying to set the session variable Session.Dog from black to Blue and have it show up as Blue on the test.cfm. It keep show'n up black. I do have Session Variables enabled via the CF Administrator page. What am I miss'n here. !--- Application.CFM --- cfapplication name=TEST sessionmanagement=Yes setclientcookies=no cflock scope=session timeout=2 cfset Session.Dog = Black /cflock !--- Test.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput cfset #Session.Dog# = Bluebr /cflock cflock scope=session type=readonly timeout=2 a href=test2.cfm?cfoutput#Session.URLTOKEN#/cfoutput Goto/abr /cflock /body /html !--- Test2.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput /cflock br /body /html - Can someone get me started here. Thanks Doug Kronenberger OI National Training and Education Office 440-526-3030 x7776 ~~ 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: Just in time compliation error
I have seen this when I have a # sign with a font color inside of a cfoutput. example: font color=#FFE0D7fsfdsf/font the # must either be escaped by using another # or use no # at all...or use a name color: white,navy,maroon etc. also, if you use the tag editor, it will add the # BACK, if you remove it...so watch out. hope this helps... -Original Message- From: Lewis Steven [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:10 AM To: CF-Talk Subject: OT: Just in time compliation error What would cause a Just in time compilation error? ~~ 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: Post-Spectra Content Management Systems??
As for alternatives, we're taking a very close look at CommonSpot 2.0 by PaperThin ( www.paperthin.com ). I'm sure this isn't the place to mention this as I work for Live Info, but there's also Nimoi http://www.nimoi.com/ which is launching version 2 at Internet World 2001. Good for UK based people ATM. Dan. (who's helping to put the finishing touches to vrs 2 ATM) 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
RE: structure in request scope
How about using the query caching attributes of CFQUERY if your queries are pretty stable and unchanging? Regards Stephen -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 14:50 To: CF-Talk Subject: RE: structure in request scope I find it easier and simpler to put the query in request scope in the first place (not really necessary) and cache it. That way, none of the below is necessary. best, paul At 09:27 AM 5/11/01 -0400, you wrote: And to wrap it all up You want to write the query in a persistent scope. But since every time you write to or access a persistent scope you must lock the access, you want to copy the query to the request scope in the application.cfm. This way you will only nead to bother with the locking process when creating the query and copying to the request scope. Everywhere else in your site you'll call the request variable to access the query info... and you won't have to use a lock. so your application.cfm would look something like this. !--- Create the query in a persistent scope --- cflock scope=APPLICATION throwontimeout=No timeout=1 type=EXCLUSIVE cfif NOT isdefined(application.myquery) cfquery name=application.myquery datasource=mydsn [SQL Stuff] /cfquery /cfif /cflock !--- Copy the query to the request scope --- cflock scope=APPLICATION throwontimeout=No timeout=1 type=READONLY cfset request.myquery = duplicate(application.myquery) /cflock |-Original Message- |From: Sean Daniels [mailto:[EMAIL PROTECTED]] |Sent: Thursday, May 10, 2001 10:54 AM |To: CF-Talk |Subject: Re: structure in request scope | | |On 5/10/01 1:59 AM Mark Ireland wrote: | | Could someone tell me how to load a structure into the |request scope in the | application.cfm | | once only when a user first visits a page. That is, check that the | structure is there and dont rerun the query code if it is | | unless a change has been made to the database. | |It sounds like you want to put the structure into a persistent |scope, which |request is not. Use the application scope instead if it is |global to all |users. If not, client or session scope. | |cfif isdefined(application.strFoo) |cflock type=exclusive scope=application name=strLock |cfset application.strFoo = structnew() |!--- etc --- |/cflock |/cfif | | |- Sean | ~~ 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
cfm-resources?
Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Tools for developers: http://developer.perthweb.com.au -- cfx_pwimageproc: image processing tool -- cfx_pwcardcrypt: credit card validation and encryption Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Data Integrity - Q of the Day
Erika, If you don't mind me plugging my own product, cfx_kmSuite contains a couple of functions that might help. If you could store your company names in a CF list, the cfx_kmList.ListBestMatch function could be used to resolve user input to an existing company name. Another option would be to use the cfx_kmMisc.Soundex function to build soundex values for each company name. You could compare the soundex of the user input to the stored soundex values. cfx_kmSuite adds more than 100 functions to Cold Fusion. I try hard to keep my customers happy. If there's something you want that isn't in the product, I'll try to add it. Documentation and purchase info for cfx_kmSuite at: http://www.hoptechno.com/kmtools/ Keith Meade [EMAIL PROTECTED] - Original Message - From: Erika L. Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 10:52 AM Subject: OT: Data Integrity - Q of the Day : Here's a question that's been bothersome for some time. : : We have an interface where participants register for meeting. There is a : form they fill out with basic information, including the pharmaceutical : company they are associated with. : : We use drop downs where we can to keep data as constant as possible, but we : cannot use dropdowns for the company they are with as there are far too many : to compile and list. : : And therein lies our problem. Users from one company can have a half dozen : different ways to spell their company name. : : There is an admin search page where an administrator can search for : registered users by several different criteria, one of which is the user's : company name. I dynamically build a drop down for this field on the search : page by pulling all distinct company names from the db. Of course, there are : several different variations of the company name in the dropdown, which : makes it very cumbersome. : : Has anyone had to deal with this? If so, how did you deal with it? And/or : does someone have an idea on how to go about dealing with it? : : : Erika : (with a *K*) : : : ~~ 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: the dbl devil
Just as an aside... Its not actually your application that's holding your database open. By default, ODBC is set to maintain connections. This is a good and a bad thing. Good because it is more efficient to maintain a connection to the database than to re-make the connection each time you query, insert or update any of your database tables. Bad because it means that its difficult to update your database, but, as Chris says, as long as you are using CF 4.5.x then you can use the cfusion_dbconnections_flush()function. One thing to say about that function - Use it sparingly The function will flush _all_ database connections. This means that not only will connections to your database, but everyone else's connections too. So potentially you could upset all the other people hosted on the same server as you, if you use it too often and affect the performance of their applications. If you're on a dedicated server and have access to the CF Administrator, then you can also flush DB connections from the Verify Data Source menu item. Regards Stephen PS. Does anyone know if you can specify a datasource name as an attribute of cfusion_dbconnections_flush(), so that it will release only the named datasource? -Original Message- From: Chris Maloney [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 14:48 To: CF-Talk Subject: RE: the dbl devil Megan, Provided you are using CF4.5.x you should be able to use the cfusion_dbconnections_flush() function to release the database. You do need to make sure that from the time you release the connection to the time you delete the database or replace it that no database accesses are done, otherwise the database will again be locked. The use of 'date' as a field name is a pretty common mistake, it would be nice if Access provided warnings about this when you create a database but it does not. Chris -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:27 AM To: CF-Talk Subject: the dbl devil Hi all, I'm using Access for my database. Sometimes when I need to make changes to the database on the server there is a .dbl file in the directory. I can't delete it, and it won't let me upload the database. A couple days ago someone on this list said to create a query calling a table that doesn't exist. I did that. Got the error on the screen, but the devilish dbl was still there. I talked to my cf host and he said, Your code is holding your database too long..put in your code a time to release the database after so many minutes. Does anyone know what he was talking about? Also, thanks for your assistance on my syntax error when inserting date. I was thrown off because cfinsert and cfupdate worked fine. But all went awry when I tried to use insert in a query in a cfloop. So changing the field name from date to classdate did the trick. Thanks! Megan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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 style sheets
Just a note here, I tried to map .js files to cf in iis and it didn't parse them as cf when called as LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I would bet it doesn't like css files much better in that format. If anyone has had any luck configuring cf to parse these files I would like to get your method. Thanks, Frederic Sean Daniels wrote: On 5/10/01 1:27 PM Scott Weikert wrote: 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. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ 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: cfm-resources?
www.atswebnet.com 4.95 a month kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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: cfm-resources?
sorry, 6.95 :) ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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) cfm-resources?
just ran a query on netcraft.. http://uptime.netcraft.com/up/graph?mode_u=offmode_w=onsite=www.cfm-re sources.comsubmit=Examine the avg shown is low/normal is suppose. i too am interested to know if anyone here is hosting any site(s) under paid accts?? their prices are best suited for me as i have some 5 sites that i am thinking to host. any info?? TIA ::akbar -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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: cfm-resources?
Sorry to bug you Kay, I was just wondering if you received the last messages I sent to CF - talk. I just joined today and I want to make sure that I am using it correctly. thanks in advance, Dave MacDiarmid Engineering Web Administrator NetManage, Inc. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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: Session Variables - I don't get it
Got it. So... it's a runs the application.cfm before every page thing. Hey, that could be useful. I have had an epiphany. I understand it all now (even why they have brail on drive up teller machines). Thank you all. -Original Message- From: Per Kleven [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:15 AM To: CF-Talk Subject: RE: Session Variables - I don't get it Hi You're setting the session.dog variable to Black EACH time in your application file, and in your test.cfm file to Blue AFTER it's outputted. So when you output it, it's set to black. use cfparam name=session.dog default=black in the application.cfm file, and cfset session.dog = blue BEFORE cfoutput#session.dog#/cfoutput in the test.cfm file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kronenberger, Douglas Sent: 11. mai 2001 15:50 To: CF-Talk Subject: Session Variables - I don't get it Greetings, I'm not getting how to implement session variables. I'm just trying to set the session variable Session.Dog from black to Blue and have it show up as Blue on the test.cfm. It keep show'n up black. I do have Session Variables enabled via the CF Administrator page. What am I miss'n here. !--- Application.CFM --- cfapplication name=TEST sessionmanagement=Yes setclientcookies=no cflock scope=session timeout=2 cfset Session.Dog = Black /cflock !--- Test.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput cfset #Session.Dog# = Bluebr /cflock cflock scope=session type=readonly timeout=2 a href=test2.cfm?cfoutput#Session.URLTOKEN#/cfoutput Goto/abr /cflock /body /html !--- Test2.CFM --- html body cflock scope=session timeout=2 cfoutput #Session.Dog# /cfoutput /cflock br /body /html - Can someone get me started here. Thanks Doug Kronenberger OI National Training and Education Office 440-526-3030 x7776 ~~ 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
Verity on an intranet
Hey everyone, I am trying to find a solution to why I can't create/index a collection which consists of files on another machine on my intranet. When I click browse server I only get my local drives showing up. I can't believe that this problem would have such a complex solution. thanks in advance, Dave MacDiarmid Engineering Web Administrator NetManage Inc. Ottawa, Canada -Original Message- From: Keith Meade [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:40 AM To: CF-Talk Subject: Re: Data Integrity - Q of the Day Erika, If you don't mind me plugging my own product, cfx_kmSuite contains a couple of functions that might help. If you could store your company names in a CF list, the cfx_kmList.ListBestMatch function could be used to resolve user input to an existing company name. Another option would be to use the cfx_kmMisc.Soundex function to build soundex values for each company name. You could compare the soundex of the user input to the stored soundex values. cfx_kmSuite adds more than 100 functions to Cold Fusion. I try hard to keep my customers happy. If there's something you want that isn't in the product, I'll try to add it. Documentation and purchase info for cfx_kmSuite at: http://www.hoptechno.com/kmtools/ Keith Meade [EMAIL PROTECTED] - Original Message - From: Erika L. Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 10:52 AM Subject: OT: Data Integrity - Q of the Day : Here's a question that's been bothersome for some time. : : We have an interface where participants register for meeting. There is a : form they fill out with basic information, including the pharmaceutical : company they are associated with. : : We use drop downs where we can to keep data as constant as possible, but we : cannot use dropdowns for the company they are with as there are far too many : to compile and list. : : And therein lies our problem. Users from one company can have a half dozen : different ways to spell their company name. : : There is an admin search page where an administrator can search for : registered users by several different criteria, one of which is the user's : company name. I dynamically build a drop down for this field on the search : page by pulling all distinct company names from the db. Of course, there are : several different variations of the company name in the dropdown, which : makes it very cumbersome. : : Has anyone had to deal with this? If so, how did you deal with it? And/or : does someone have an idea on how to go about dealing with it? : : : Erika : (with a *K*) : : : ~~ 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
oracle LOB query problem
I have defined a column as CLOB in an oracle 8i table and when CF return Unknown Data Access Error when i do an query on this table. If i remove the CLOB column from the table the query works fine. Anyone has suggestions to resolve this problem. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ 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 style sheets
Note to note... All I did was LINK REL=StyleSheet TYPE=text/css HREF=style.cfm, with no changes to iis, and it worked fine. (Which doesn't affect my earlier point that there's nothing gained in doing this.) Robert -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:59 AM To: CF-Talk Subject: Re: CF and custom style sheets Just a note here, I tried to map .js files to cf in iis and it didn't parse them as cf when called as LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I would bet it doesn't like css files much better in that format. If anyone has had any luck configuring cf to parse these files I would like to get your method. Thanks, Frederic Sean Daniels wrote: On 5/10/01 1:27 PM Scott Weikert wrote: 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. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ 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
Moving files via Stored Procedure
Need to move an excel sheet from drive[C:] over to drive[E:], I need this done via a stored procedure. Does anyone have any experience with doing this?? I found an article on M$, but you have to basically decrypt the thing to understand it. David Sterling Square One Inc. Allaire Certified ColdFusion Developer ~~ 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_DOWNLOAD -- need fix ASAP
Hi All. Anyone successfully downloading files from server to client? We are running tests on Monday and help would be appreciated. I have retrieved the cf_download tag (from the server to the client box) and am trying to use it -- somewhat unsucessfully. In NETSCAPE, the download pop-up window works fine and asks the user if they want to save the correct TXT file. This is good. I am happy. In IE, the download pop-up asks the user if they want to save the CFM file that is the referrer page, if the user clicks on OPEN, then the download window asks if they want to save the CFM script_name. if the user clicks on OPEN, THEN the download window asks the user if they want to save the correct TXT file. This is not good. I am not happy. My boss want both to work the same. NETSCAPE always shows the download pop-up window. So, I have to make them both work the same. Any and all suggestions are welcome. Thanks, 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: New Cold Fusion book, O'riely Press
Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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: Running DTS in Stored rocedure
I haven't used SQL7 in awhile, but one thing you might try, if you have the option, is running ColdFusion under a local administrator account, rather than as Local System. This might solve that problem. Bob -Original Message- From: David Sterling [mailto:[EMAIL PROTECTED]] Sent: May 10, 2001 7:18 PM To: CF-Talk Subject: RE: Running DTS in Stored rocedure Im running SQL 7.0 on an NT4. -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 3:53 PM To: CF-Talk Subject: RE: Running DTS in Stored rocedure What version of SQL server are you running? I just had to set something like this up on SQL2000, and there are a few pointers I can give you. Also, which password are you referring to? The user login password, the package password, etc? Thanks, Bob -Original Message- From: David Sterling [mailto:[EMAIL PROTECTED]] Sent: May 10, 2001 3:18 PM To: CF-Talk Subject: Running DTS in Stored rocedure I am having problems running a DTS package from a stored procedure... Here is my code: CREATE PROCEDURE [run_TestDTS] AS Exec MASTER..xp_CmdShell 'dtsrun /sql01/testun/testpass/testDTS' I keep getting this error.. ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.c: Error 997 from GetPassword on line 465 The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (23:5) to (23:64). I have changed the password, from the owner password, to the user password, to my login password for SQL.. ~~ 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: Moving files via Stored Procedure
The simplest way to do this would be using xp_cmdshell with a command or a batch file. Although I understand from a previous note that you're having trouble getting that to run (xp_cmdshell). If my previous suggestion for your DTS problem didn't work, feel free to email me off list and I'll try to give you a hand. Thanks, Bob -Original Message- From: David Sterling [mailto:[EMAIL PROTECTED]] Sent: May 11, 2001 12:39 PM To: CF-Talk Subject: Moving files via Stored Procedure Need to move an excel sheet from drive[C:] over to drive[E:], I need this done via a stored procedure. Does anyone have any experience with doing this?? I found an article on M$, but you have to basically decrypt the thing to understand it. David Sterling Square One Inc. Allaire Certified ColdFusion Developer ~~ 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
registering cfx tag without administrator
Is there any way of registering a new CFX tag without going through the administrator? We don't have access... Jennifer Francis ATT Wireless * [EMAIL PROTECTED] ATT Proprietary - Use pursuant to company instructions Attention: Information contained in this EMAIL, including attachments, may contain sensitive or ATT proprietary information. Please use pursuant to company instructions. Take care not to disclose proprietary information, and forward this EMAIL and its attachments with caution only to those that have a need to have this information. ~~ 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
Order By
How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: New Cold Fusion book, O'riely Press
i'll let ben give the formal answer, but i think he passed on 4.5 to do a full release for 5.0. -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:11 AM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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
CF 5.0 graphs
Hi All, I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... Thanks, Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ 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: New Cold Fusion book, O'riely Press
Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:11 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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
COMPILATION - ODBC does not like Overloaded Stored Procedures Was : (Oracle stored procedure question.)
After a round of testing we found the ODBC does not like overloaded Stored Procedures for Oracle. Don't know if this the case for SQL Server but we separated out the overloaded SP's and everything works fine Kevin -Original Message- From: Kevin Gilchrist Sent: Friday, May 04, 2001 11:25 AM To: CF-Talk (E-mail) Subject: Oracle stored procedure question. Hi All, I need another set of eyes on a problem. I have a piece of code that calls an Oracle stored procedure that just refuses to work with either the Oracle or Microsoft ODBC drivers on my personal development Win2K box (CF Pro 4.5.1 SP2). However, it does work with the Oracle native drivers though on our Solaris production machine. The code in question is: cfstoredproc procedure=redsiren_api.create_node datasource=ROC debug=Yes CFPROCPARAM type=In cfsqltype=CF_SQL_VARCHAR value=#form.Node# CFPROCPARAM type=In cfsqltype=CF_SQL_VARCHAR value=#form.System_Type# cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#form.Agent_port# null=No CFPROCPARAM type=In cfsqltype=CF_SQL_VARCHAR value=#form.IP_Address# CFPROCPARAM type=In cfsqltype=CF_SQL_VARCHAR value=Y CFPROCPARAM type=In cfsqltype=CF_SQL_VARCHAR value=S cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#session.site_id# null=No CFPROCPARAM type=Out cfsqltype=CF_SQL_VARCHAR variable=return /CFSTOREDPROC The MS driver throws back an error message about there being a bad parameter datatype, while the Oracle driver just says that there's a syntax violation. I've double-checked the data-types and I'm pretty sure that they're right and that all the variable values are OK as it works with the native driver. I shouldn't have to wrap anything is single quotes right because CFSTOREDPROC will do this as appropriate, right? If I do a desc of the SP in SQL PLus, I get: PROCEDURE CREATE_NODE Argument Name TypeIn/Out Default? -- --- -- NODE VARCHAR2IN SYSTEM_TYPEVARCHAR2IN AGENT_PORT NUMBER IN IP_ADDRESS VARCHAR2IN MONITORED VARCHAR2IN REF_CODE VARCHAR2IN REF_ID NUMBER IN RETURN_STATUS VARCHAR2OUT Any ideas as to how I can get the code above to work with CF Pro? I've upgraded both sets of ODBC drivers on my Win2K box to the latest and greatest etc. We're eventually going to get another CF Enterprise license for a Solaris test box although that doesn't help me right now. I hate testing on a production box (although the app I'm writing is only in the dev stage so it's not as if I'm messing with a live app) Any suggestions would be really appreciated! Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ 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: oracle LOB query problem
I just worked through an issue like this. When using the CLOB in a select or where clause, you will need to use the oracle function:dbms_lob.instr() For example, on one of our Spectra sites running in oracle, the longcharfield of the properties table is a CLOB. To match a particular record from that table, we use the following: CFQUERY name=qry_test datasource=#REQUEST.CFA.OBJECTSTORE.DSN# select objectID from properties WHERE dbms_lob.instr(longchardata, '#HEADLINE#')0 and propertyname='HEADLINE' /CFQUERY Hope this helps. At 09:30 AM 5/11/01 -0700, you wrote: I have defined a column as CLOB in an oracle 8i table and when CF return Unknown Data Access Error when i do an query on this table. If i remove the CLOB column from the table the query works fine. Anyone has suggestions to resolve this problem. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ 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: New Cold Fusion book, O'riely Press
There is currently a CF5.0 book in the works from Ben Forta et. al. At 10:11 AM 5/11/01 -0700, you wrote: Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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
CFSELECT Question
Ok, I know this tag pretty well, but what I am trying to do is combine two columns and do a little formatting to them, but have that come up in the display of the CFSELECT Tag, now i just get errors when i try to directly apply the formatting within the display value of the tag, can someone guide me in the right direction on wether this is even possible??? cfselect name=getphonenums query=getinformation value=ratecenterid display=ratecenter #Left(phonenumber, 6)# thanks kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ 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: Order By
You could put them in descending order with ORDER BY value DESC J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Pessimism - Every dark cloud has a silver lining, but lightning kills hundreds of people each year who are trying to find it. ~despair.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:33 AM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: CF 5.0 graphs
As CF Studio 5 will be out a while after CF5 ships, a set of add-on VTM's will be made available for Studio 4.5.2. They've already been written (so you don't need to do so), and will be available when CF5 is available. --- Ben -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:30 PM To: CF-Talk Subject: CF 5.0 graphs Hi All, I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... Thanks, Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ 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: Order By
Depends on what you want to order it by a table of 10 values numbered 1 - 10. cfquery name=getlast datasource=yourdata maxrows=1 SELECT * FROM Numbers ORDER BY NumberID DESC(descending) ASC(ascending) /cfquery cfoutput #getlast.numberid# /cfoutput Use only DESC or ASC in your Order By statement hth kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:33 AM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: registering cfx tag without administrator
Hello Jennifer, If you have access to the cfregistry tag then you can (hypothethically) as I have found that for some reason all the tags I register this way do not take effect until I update them in the cfadmin.. -- Best regards, Crittermailto:[EMAIL PROTECTED] --- Friday, May 11, 2001, 1:18:48 S2K, you wrote: FJ Is there any way of registering a new CFX tag without going through the FJ administrator? We don't have access... FJ Jennifer Francis FJ ATT Wireless FJ * [EMAIL PROTECTED] FJ ATT Proprietary - Use pursuant to company instructions FJ Attention: Information contained in this EMAIL, including attachments, may FJ contain sensitive or ATT proprietary information. Please use pursuant to FJ company instructions. Take care not to disclose proprietary information, FJ and forward this EMAIL and its attachments with caution only to those that FJ have a need to have this information. FJ ~~ 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: cfm-resources?
I have been having problems with them with my free account, and a friend of mine that has a pay account with them can not get a hold of them either, no matter how many emails Robert J. Bailey (646) 526-4536 -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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: Order By
Based on your SQL in the ORDER BY line add DESC which is Descending. Example: ORDER BY FIELDNAME DESC ** Replace FIELDNAME with an actual field name in the SQL -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:33 PM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: Order By
Use DESC... SELECT FIELD1 FROM TABLENAME ORDER BY FIELD1 DESC Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (561) 423-2674 http://www.hallofsports.com .. . . where the legends live on -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:33 PM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: Order By
In your SQL: ORDER BY myField DESC Bob -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: May 11, 2001 1:33 PM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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
WHERE statement with multiple ANDs
I am a little confused as to how to code a WHERE statement that has more than one qualifier. See this code: CFQUERY NAME=qGetStatus DATASOURCE=VISN SELECT Location, Date_rcvd, status, Certificate_Number FROM 39_TRACKING WHERE Location = '#form.location#' AND status = '#form.status# AND date_rcvd #DateFormat(CreateODBCDate(Form.firstdate), 'm/d/')# AND date_rcvd #DateFormat(CreateODBCDate(Form.seconddate), 'm/d/')# Group Bylocation, date_rcvd, status, certificate_number /CFQUERY The queary does not work. Do I need to use parentheses in a WHERE statement with a number of AND's? Is it even a good idea to use this many AND's or is there another way I should be doing this? Tim ~~ 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: New Cold Fusion book, O'riely Press
And since we are talking books - the Mastering CF 5 is coming out as well. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:27 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben ~~ 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: Order By
select top 1 punkass, ibtoad, com from houseoffusion order by toad desc ibtoad [EMAIL PROTECTED] on 05/11/2001 12:33:25 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: Order By
Oops. select top 1 punkass, ibtoad, com from houseoffusion order by ibtoad desc -- Forwarded by Casey C Cook/TMG/CSC on 05/11/2001 01:09 PM --- Casey C Cook/TMG/CSC 05/11/2001 01:07 PM To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: Order By (Document link: Casey C Cook) select top 1 punkass, ibtoad, com from houseoffusion order by toad desc ibtoad [EMAIL PROTECTED] on 05/11/2001 12:33:25 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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
Parsing .js files in cf...was CF and custom style sheets
I take your point. I have had a reason for trying to parse .js files through cf though. I was trying to use CF to dynamically generate the menu arrays in the dhtml HierMenu scripts. This would not work because any cf code that I tried to use was being caught as a js syntax error because it was not being parsed by cf. I could modify the version 3.X scripts and get them to work with coldfusion but I have tried just about everything to get the 4.X version to work with cf but they do not seem compatible. I tried adding .js files to be parsed by cfserver but that didn't work. I didn't get an error but the menus did not get built. Has anyone had any luck using hiermenus 4.X with cf? [EMAIL PROTECTED] wrote: Note to note... All I did was LINK REL=StyleSheet TYPE=text/css HREF=style.cfm, with no changes to iis, and it worked fine. (Which doesn't affect my earlier point that there's nothing gained in doing this.) Robert -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:59 AM To: CF-Talk Subject: Re: CF and custom style sheets Just a note here, I tried to map .js files to cf in iis and it didn't parse them as cf when called as LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I would bet it doesn't like css files much better in that format. If anyone has had any luck configuring cf to parse these files I would like to get your method. Thanks, Frederic Sean Daniels wrote: On 5/10/01 1:27 PM Scott Weikert wrote: 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. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ 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: [Re: Native Drivers - Oracle80]
Did you restart the server or at least the CF services? I've made that mistake after installing Oracle client software a couple of times. Also check and make sure you're using the same host string, username and password in CF Admin because that should certainly work if SQL*Plus works. Good luck Duncan Hays -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:56 AM To: CF-Talk Subject:Re: [Re: Native Drivers - Oracle80] I am running into the same problem. I can connect to it via SqlPlus on the same machine and I have it running fine on another server. Any clues? Should I reinstall the oracle client? Thanks Tim P. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:13 AM Subject: Re: [Re: Native Drivers - Oracle80] ... you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also Yes, I had Oracle 8 client software installed and have created a service name, ABC. On the CF Settings page: DSN: ABC Host String: 127.0.0.1:1521 ColdFusion Login: ABCowner/** I created ABCowner NT user account with Admin right. What else did I miss? Regards, Julia Phu Tom Davison [EMAIL PROTECTED] wrote: did you install the oracle 8 client software on the server? when you do you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also. - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 4:26 PM Subject: Native Drivers - Oracle80 Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Are the data soruces setting configured properly? --- I believed I did --- * Did you provide valid security information in the data source settings? --- Honestly, I'm not quite sure what it means. --- * For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Window NT Services Control Panel to change the account the ColdFusion Server service is using. --- Again, I believed I did what it said. --- On the Oracle house, I have one sid with 2 instances. I need a connection to instance2. I'm stumbled on this problem for two days and couldn't find any material or expertise of the failure. Your enlightenment is greatly appreciated. Salute, Julia Phu ~~ 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: CFHTTP and port numbers
Thanks a lot Jeff, Yes it is rather simple once you RTFM realise there's a port number attribute... blush It's not in Ben's book for some reason, which is what I usually use for reference. Thanks Nick -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:24 AM To: CF-Talk Subject: RE: CFHTTP and port numbers Nick, This might sound rather simple, but are you using the port attribute of CFHTTP or typing it into the address line? cfhttp url=http://foo.bar.com; method=GET port=6660 resolveurl=true /cfhttp I don't think that http://foo.bar.com:6660 will work in the address line. Jeff -Original Message- From: DeVoil, Nick To: CF-Talk Sent: 5/10/01 1:07 AM Subject: CFHTTP and port numbers It seems that CFHTTP cannot connect to an address of the form http://foo.bar.com:6660 Can anyone confirm this and/or tell me how I can make an HTTP request to an address like this? Thanks Nick ** 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
NS compatable browser-based WYSIWYG editors
Hello all, Anyowne know of a browser-based WYSIWYG editor such as ActivEdit or ezEdit that's funcitonal in Netscape? I don't need it to be very advanced. I'm putting together a bare bones content management system and all I really need is the ability to link text and make basic font adjustments (bold, italics). If not, any bright ideas for a work around? Thanks for any suggestions/ideas. Bill ~~ 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: Order By
Test. Bob Silverberg [EMAIL PROTECTED] on 05/11/2001 12:50:00 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Order By In your SQL: ORDER BY myField DESC Bob -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: May 11, 2001 1:33 PM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, 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: CFSELECT Question
No, I think cfselect NEEDS just a field name. You CAN do what you want directly in your query. The syntax will differ with DBMS, but with SQLServer you can do: cfquery ... SELECT 'ratecenter '+substring(phonenum,6) as myRateField /cfquery and then you could use myRateField in your cfselect. -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:31 AM To: CF-Talk Subject: CFSELECT Question Ok, I know this tag pretty well, but what I am trying to do is combine two columns and do a little formatting to them, but have that come up in the display of the CFSELECT Tag, now i just get errors when i try to directly apply the formatting within the display value of the tag, can someone guide me in the right direction on wether this is even possible??? cfselect name=getphonenums query=getinformation value=ratecenterid display=ratecenter #Left(phonenumber, 6)# thanks kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ 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
loop puzzle....
Can anyone explain why this is happening? the first valuelist prints perfectly, the second one throws this error: Parameter 1 of function ValueList which is now prod.productID must be pointing to a valid query name They are identical, and the only thing between them is the loop you see below. (The loop runs fine, too) The loop seems to delete the value of the query (???) cfoutput #valuelist(prod.productID)# cfloop list=#valuelist(prod.productID)# index=prod cfparam name=total#prod# default=0 cfparam name=amttotal#prod# default=0 /cfloop #valuelist(prod.productID)# /cfoutput TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long ~~ 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: WHERE statement with multiple ANDs
Look up the BETWEEN operator -- it is your friend -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:50 AM To: CF-Talk Subject: WHERE statement with multiple ANDs I am a little confused as to how to code a WHERE statement that has more than one qualifier. See this code: CFQUERY NAME=qGetStatus DATASOURCE=VISN SELECT Location, Date_rcvd, status, Certificate_Number FROM 39_TRACKING WHERE Location = '#form.location#' AND status = '#form.status# AND date_rcvd #DateFormat(CreateODBCDate(Form.firstdate), 'm/d/')# AND date_rcvd #DateFormat(CreateODBCDate(Form.seconddate), 'm/d/')# Group Bylocation, date_rcvd, status, certificate_number /CFQUERY The queary does not work. Do I need to use parentheses in a WHERE statement with a number of AND's? Is it even a good idea to use this many AND's or is there another way I should be doing this? Tim ~~ 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
Window sizing with a CFTREEITEM target
I'd like to include size, scrollbar, and toolbar parameters for a _blank new window target from a CFTREEITEM href. Seems one cannot nest any non-native events, calls, or direct script within the applet. While this comes as no surprise, I wonder regardless if anyone has found a way. Paul Davies _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity on an intranet
Your problem is because the adminstrator applet that shows you files doesn't recognize network drives. You can write CF code to index your varity collections -- see the CFINDEX tag. THIS tag CAN take network names like \\joesServer\hisdocuments -Original Message- From: MacDiarmid, David [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:51 AM To: CF-Talk Subject: Verity on an intranet Hey everyone, I am trying to find a solution to why I can't create/index a collection which consists of files on another machine on my intranet. When I click browse server I only get my local drives showing up. I can't believe that this problem would have such a complex solution. thanks in advance, Dave MacDiarmid Engineering Web Administrator NetManage Inc. Ottawa, Canada ~~ 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: cfm-resources?
You might want to move to a language such as PHP, Perl, (ick) ASP, etc. Using CF, which is really meant to be an enterprise product and costs min. $1.2k USD, might not be the solution. I realise it's often much more rapid development and has a quicker learning curve overall, but PHP and Perl are free, ASP is in the sense it can be hosted w/ chillisoft bypassing having to pay for the OS... Server such as this have lower operating costs to begin w/ so can often offer much lower rates. I'm almost sure to get flamed for suggesting something other than CF, but it's all about the right tool for the job. If the site will be manageable enough through your admin section then the need for someone unskilled to edit the source won't occur frequently. Just a though. -Original Message- From: Robert J. Bailey [mailto:[EMAIL PROTECTED]] Sent: May 11, 2001 10:41 To: CF-Talk Subject: RE: cfm-resources? I have been having problems with them with my free account, and a friend of mine that has a pay account with them can not get a hold of them either, no matter how many emails Robert J. Bailey (646) 526-4536 -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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: ASPEncrypt ASPUpload
I have used a number of the Persits components without problems. I didn't use the two specific ones that you mention and it's been a year or so since I used them. Steve -Original Message- From: Per Kleven [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:49 AM To: CF-Talk Subject: ASPEncrypt ASPUpload Have any of you guys used these objects in CF ?? ( www.aspencrypt.com www.aspupload.com ) - Per ~~ 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 5.0 graphs
Thank you Mr. Forta! Just started looking at the graph tag and it's pretty cool that you can create drilldown graphs by clicking on data points. We were about to go out and get Crystal Reports but now we're just going to wait until CF 5.0 comes out though it's a pain the Solaris release ain't happening until August (surprised that HP was coming before Solaris?). If we want to use CF 5.0 as a method of generating canned reports would it be possible to save generated reports to a disk? We want to generate them at off-peak hours etc. I know you can use CFFILE to write a file to disk, but would it work to more-or-less put a whole report in the output attribute? Can you run any CF tags inside the output attribute? Just that any accompanying graphics in a report would have to be written to disk also -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:34 PM To: CF-Talk Subject: RE: CF 5.0 graphs As CF Studio 5 will be out a while after CF5 ships, a set of add-on VTM's will be made available for Studio 4.5.2. They've already been written (so you don't need to do so), and will be available when CF5 is available. --- Ben -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:30 PM To: CF-Talk Subject: CF 5.0 graphs Hi All, I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... Thanks, Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ 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: Parsing .js files in cf...was CF and custom style sheets
I can't address the question directly, but if you want to parse .js files through CF, wouldn't this work: SCRIPT LANGUAGE=JavaScript TYPE=text/javascript src=script.cfm/SCRIPT Robert -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:11 PM To: CF-Talk Subject: Parsing .js files in cf...was CF and custom style sheets I take your point. I have had a reason for trying to parse .js files through cf though. I was trying to use CF to dynamically generate the menu arrays in the dhtml HierMenu scripts. This would not work because any cf code that I tried to use was being caught as a js syntax error because it was not being parsed by cf. I could modify the version 3.X scripts and get them to work with coldfusion but I have tried just about everything to get the 4.X version to work with cf but they do not seem compatible. I tried adding .js files to be parsed by cfserver but that didn't work. I didn't get an error but the menus did not get built. Has anyone had any luck using hiermenus 4.X with cf? [EMAIL PROTECTED] wrote: Note to note... All I did was LINK REL=StyleSheet TYPE=text/css HREF=style.cfm, with no changes to iis, and it worked fine. (Which doesn't affect my earlier point that there's nothing gained in doing this.) Robert -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:59 AM To: CF-Talk Subject: Re: CF and custom style sheets Just a note here, I tried to map .js files to cf in iis and it didn't parse them as cf when called as LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I would bet it doesn't like css files much better in that format. If anyone has had any luck configuring cf to parse these files I would like to get your method. Thanks, Frederic Sean Daniels wrote: On 5/10/01 1:27 PM Scott Weikert wrote: 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. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ 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: New Cold Fusion book, O'riely Press
Well, I guess the following should give you a good idea of what will hit the shelves in the following 3-4 months (in cronological order): Professional ColdFusion 4.5 by Wrox Author Team Paperback - 1000 pages (May 2001) Wrox Press Inc ISBN: 1861004540 Programming ColdFusion by Rob Brooks-Bilson 900 pages pages (July 2001) O'Reilly Associates ISBN: 1565926986 Optimizing Coldfusion by Chris Cortes Paperback - 400 pages (June 2001) Osborne McGraw-Hill ISBN: 0072132663 Instant Coldfusion 5 by Jeffry Houser Paperback - 640 pages (July 2001) Osborne McGraw-Hill ISBN: 0072132388 ColdFusion 5.0 Web Application Construction Kit by Ben Forta Paperback - 900 pages (July 19, 2001) Que ISBN: 0789725843 Mastering ColdFusion 5 by Arman Danesh, Kristin Aileen Motlagh, Raymond Camden Paperback - 1104 pages (August 15, 2001) Sybex ISBN: 078212979X ColdFusion Administrator's Guide by Prima (Editor), Prima Development Hardcover - 750 pages (August 30, 2001) Prima Publishing ISBN: 0761534792 Massimo ~~ 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 5.0 graphs
I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... No tag editors yet, but Dave Gallerizzo just did a CFUG presentation on CFGRAPH. If you're interested, you might take a look at this: http://www.figleaf.com/figleafhome/cfug/cfugmay2001.zip It's not much, but there are code samples. There'll be new VTM files available shortly from Allaire. 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: NS compatable browser-based WYSIWYG editors
I thought that Netscape came WITH such a thing? Composer I think it was called. Check out your Netscape menus and see if it has an edit option and go to town! -Original Message- From: Bill Holloway [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:24 AM To: CF-Talk Subject: NS compatable browser-based WYSIWYG editors Hello all, Anyowne know of a browser-based WYSIWYG editor such as ActivEdit or ezEdit that's funcitonal in Netscape? I don't need it to be very advanced. I'm putting together a bare bones content management system and all I really need is the ability to link text and make basic font adjustments (bold, italics). If not, any bright ideas for a work around? Thanks for any suggestions/ideas. Bill ~~ 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: cfm-resources?
Upgrade to the Bronze account for $5 for LIFE. Seems to be much more reliable than the free accounts. Andrew - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 9:39 AM Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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: New Cold Fusion book, O'riely Press
SO it is available now Ben? Just at amazon.com? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:27 AM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:11 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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: New Cold Fusion book, Osborne McGraw Hill
And while we are at it, Instant ColdFusion will be out soon as well. It is now available (pre-order) on Amazon.com http://www.amazon.com/exec/obidos/ASIN/0072132388/qid%3D989608220/instantcoldfu-20 Unlike most of the books out there, this one is not intended as a tutorial. Each chapter sets out to step the user through the process of creating a real-world application, starting from database design and moving up to a finished product. I've been assured that the typo in the cover (can you find it?) will be fixed. At 01:52 PM 05/11/2001 -0400, you wrote: And since we are talking books - the Mastering CF 5 is coming out as well. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:27 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben ~~ 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: loop puzzle....
Yes, certainly it does. when you use that same variable name as the loop index. Change the name of your loop index. call it iProd maybe like this: cfloop list=#valuelist(prod.productID)# index=iProd cfparam name=total#iProd# default=0 cfparam name=amttotal#iProd# default=0 /cfloop and your problems will disappear -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:30 AM To: CF-Talk Subject: loop puzzle Can anyone explain why this is happening? the first valuelist prints perfectly, the second one throws this error: Parameter 1 of function ValueList which is now prod.productID must be pointing to a valid query name They are identical, and the only thing between them is the loop you see below. (The loop runs fine, too) The loop seems to delete the value of the query (???) cfoutput #valuelist(prod.productID)# cfloop list=#valuelist(prod.productID)# index=prod cfparam name=total#prod# default=0 cfparam name=amttotal#prod# default=0 /cfloop #valuelist(prod.productID)# /cfoutput TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long ~~ 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
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: New Cold Fusion book, O'riely Press
No, they are taking advanced orders, but it is still a month away. --- Ben -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 3:12 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press SO it is available now Ben? Just at amazon.com? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:27 AM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:11 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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: Window sizing with a CFTREEITEM target
Yes, I have completely replaced our cftree with the Joust Menu System at (http://www.ivanpeters.com/). I have yet to run across something that I CANNOT do with this. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Paul Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:39 PM To: CF-Talk Subject: Window sizing with a CFTREEITEM target I'd like to include size, scrollbar, and toolbar parameters for a _blank new window target from a CFTREEITEM href. Seems one cannot nest any non-native events, calls, or direct script within the applet. While this comes as no surprise, I wonder regardless if anyone has found a way. Paul Davies ~~ 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: Verity on an intranet
Map the drive. Tools: Map Network Drive in you Explorer on NT. -Original Message- From: MacDiarmid, David [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:51 AM To: CF-Talk Subject: Verity on an intranet Hey everyone, I am trying to find a solution to why I can't create/index a collection which consists of files on another machine on my intranet. When I click browse server I only get my local drives showing up. I can't believe that this problem would have such a complex solution. thanks in advance, Dave MacDiarmid Engineering Web Administrator NetManage Inc. Ottawa, Canada -Original Message- From: Keith Meade [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:40 AM To: CF-Talk Subject: Re: Data Integrity - Q of the Day Erika, If you don't mind me plugging my own product, cfx_kmSuite contains a couple of functions that might help. If you could store your company names in a CF list, the cfx_kmList.ListBestMatch function could be used to resolve user input to an existing company name. Another option would be to use the cfx_kmMisc.Soundex function to build soundex values for each company name. You could compare the soundex of the user input to the stored soundex values. cfx_kmSuite adds more than 100 functions to Cold Fusion. I try hard to keep my customers happy. If there's something you want that isn't in the product, I'll try to add it. Documentation and purchase info for cfx_kmSuite at: http://www.hoptechno.com/kmtools/ Keith Meade [EMAIL PROTECTED] - Original Message - From: Erika L. Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 10:52 AM Subject: OT: Data Integrity - Q of the Day : Here's a question that's been bothersome for some time. : : We have an interface where participants register for meeting. There is a : form they fill out with basic information, including the pharmaceutical : company they are associated with. : : We use drop downs where we can to keep data as constant as possible, but we : cannot use dropdowns for the company they are with as there are far too many : to compile and list. : : And therein lies our problem. Users from one company can have a half dozen : different ways to spell their company name. : : There is an admin search page where an administrator can search for : registered users by several different criteria, one of which is the user's : company name. I dynamically build a drop down for this field on the search : page by pulling all distinct company names from the db. Of course, there are : several different variations of the company name in the dropdown, which : makes it very cumbersome. : : Has anyone had to deal with this? If so, how did you deal with it? And/or : does someone have an idea on how to go about dealing with it? : : : Erika : (with a *K*) : : : ~~ 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: New Cold Fusion book, O'riely Press
According to amazon it's due out in a few months, it can be pre-ordered, but all that does is just make it so that when it arrives it is shipped and billed immediately. Several books in fact are about to hit the shelves, better start saving :-) 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: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 12:12 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press SO it is available now Ben? Just at amazon.com? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:27 AM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:11 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Is BEn Forta going to update his 4.0 version books to 4.5 or 5? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:24 PM To: CF-Talk Subject: Re: New Cold Fusion book, O'riely Press * Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** 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: CF 5.0 graphs
Sure, you could schedule the creation of pages as you would any other CFM pages. But, the right way to do this is to let the graphic engine cache generated graphs to improve performance - a feature available in CF Enterprise (but not Pro). --- Ben -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:53 PM To: CF-Talk Subject: RE: CF 5.0 graphs Thank you Mr. Forta! Just started looking at the graph tag and it's pretty cool that you can create drilldown graphs by clicking on data points. We were about to go out and get Crystal Reports but now we're just going to wait until CF 5.0 comes out though it's a pain the Solaris release ain't happening until August (surprised that HP was coming before Solaris?). If we want to use CF 5.0 as a method of generating canned reports would it be possible to save generated reports to a disk? We want to generate them at off-peak hours etc. I know you can use CFFILE to write a file to disk, but would it work to more-or-less put a whole report in the output attribute? Can you run any CF tags inside the output attribute? Just that any accompanying graphics in a report would have to be written to disk also -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:34 PM To: CF-Talk Subject: RE: CF 5.0 graphs As CF Studio 5 will be out a while after CF5 ships, a set of add-on VTM's will be made available for Studio 4.5.2. They've already been written (so you don't need to do so), and will be available when CF5 is available. --- Ben -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:30 PM To: CF-Talk Subject: CF 5.0 graphs Hi All, I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... Thanks, Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ 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: New Cold Fusion book, Osborne McGraw Hill
Each chapter sets out to step the user through the process of creating a real-world application, starting from database design and moving up to a finished product. - How is this not a tutorial? Jason - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 3:16 PM Subject: RE: New Cold Fusion book, Osborne McGraw Hill And while we are at it, Instant ColdFusion will be out soon as well. It is now available (pre-order) on Amazon.com http://www.amazon.com/exec/obidos/ASIN/0072132388/qid%3D989608220/instantcol dfu-20 Unlike most of the books out there, this one is not intended as a tutorial. Each chapter sets out to step the user through the process of creating a real-world application, starting from database design and moving up to a finished product. I've been assured that the typo in the cover (can you find it?) will be fixed. At 01:52 PM 05/11/2001 -0400, you wrote: And since we are talking books - the Mastering CF 5 is coming out as well. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:27 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben ~~ 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: New Cold Fusion book, Osborne McGraw Hill
Space between Cold and Fusion? Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 6:16 PM Subject: RE: New Cold Fusion book, Osborne McGraw Hill And while we are at it, Instant ColdFusion will be out soon as well. It is now available (pre-order) on Amazon.com http://www.amazon.com/exec/obidos/ASIN/0072132388/qid%3D989608220/instantcol dfu-20 Unlike most of the books out there, this one is not intended as a tutorial. Each chapter sets out to step the user through the process of creating a real-world application, starting from database design and moving up to a finished product. I've been assured that the typo in the cover (can you find it?) will be fixed. At 01:52 PM 05/11/2001 -0400, you wrote: And since we are talking books - the Mastering CF 5 is coming out as well. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:27 PM To: CF-Talk Subject: RE: New Cold Fusion book, O'riely Press Yep, both books Construction Kit and Advanced) are being revised, and will be out for CF5. Amazon.com already has one of them listed. --- Ben ~~ 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
Passing 500 client-side variables to the server
I have a string of about 500 variables that is generated client-side by JavaScript. I need to get it to the server somehow. The string is far too long to be passed in the URL. How could I get it to the server for processing? Anyone have 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: CF 5.0 graphs
Just as a heads up, if you have personal custom tags or download any from the tag gallery and you would like a personal tag editor for them, go to http://www.netwebapps.com/mytags/main.cfm and use the free custom tag wizard. After you put in the parameters for the tag it will email you a .vtm file for the tag editor. If you want to click on the banner adds the spongers make it possible to offer this tool for free. Bryan LaPlante - Original Message - From: Kevin Gilchrist [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:29 PM Subject: CF 5.0 graphs Hi All, I'm just starting to play with the new CFGRAPH tag and I was wondering if anyone's created any tag editor's for it? I guess one will appear for Studio 5.0 but just wondering anyway. If no-one has I might just take a stab at it myself... Thanks, Kevin Kevin Gilchrist Senior Consultant RedSiren Technologies Inc. (412) 281 4427 ext 466 ~~ 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!!
I assume session.total is a numeric value; try getting rid of the quotes. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 3: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