QoQ
Hello all need a little help with QoQs. How can I compare numbers in the QoQ? Example: Select numberfield >From tbl Select numberfield from qmain WHERE qmain.numberfield > 45 IF I use the ">" I get a PCODERUNTIME. error If I use GT I get the error that numberfield is not a number. I even tried #qmain.numberfield#, but then it only compares the first record. I have ran numberfield through the ISNUMBER function and get true so it is a number. Thanks for any help Rodney __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DSNless query
Hello all Hoping someone can tell me what I am missing here. We are running: CF5 NT ACCESS2K SELECT DrawingDetails.* FROM DrawingDetails WHERE DrawingDetails.ESID=5; I get the error: Error Diagnostic Information ODBC Error Code = IM002 (Data source not found and no default driver specified) [Microsoft][ODBC Driver Manager] Data source '' not found and no default driver specified Hint: In order to use ODBC data sources with Cold Fusion you must create the data source using the Data Sources page of the Cold Fusion Administrator. In addition, if you are running under Windows NT you must make sure that the Data Source is created as a System DSN in order for it to be available to ColdFusion. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (4:1) to (4:68). Date/Time: 04/03/02 15:31:44 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 137.80.60.254 Thanks for any help __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: suggestion on complicated form design.
Qforms is a great tool for validatiing forms IMHO. you can find information at Pengoworks.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 8:50 AM To: CF-Talk Subject: suggestion on complicated form design. Hello cf-talk, I'm about to build a fairly complicated form. It will require a getting a list of names, and the age and sex of each person. I will need to enforce the age and sex requirement of each name listed. Option 1. Build a form with lots many fields for name, age and sex. Once submitted, check for a value in the name field, then check for a value in the age and sex field. If there is a value in a name field, and no age or sex fields, give them the form back to fix. This sounds like a ton of work. Will need up to 12 names on the form. Option2. Ask how many names they will give, then provide a dynamic form with exactly the number of fields they need. Enforce everything. Anyother suggestions? This sounds like a real nightmare. Any tips or suggestions before I dive into this would be most appreciated! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Wednesday, March 06, 2002, at 10:43:55 AM __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Dynamic web to static
Thanks for the replies, will check into the ones dave mentioned and play around with the other options as well. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 9:10 AM To: CF-Talk Subject: Re: Convert Dynamic web to static Use CFHTTP to read the page output then use CFFILE to save it as an HTML file. Dave - Original Message - From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 10:51 AM Subject: Convert Dynamic web to static Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Convert Dynamic web to static
Hello all Is there a program out that can take a dynamice web site (i.e coldfusion w/querys) and convert it to a static web pages (just HTML/java) so that it can then be ported and run some were with out coldfusion for a demo type prentation. THanks for any info __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT-possible IIS problem
Hello all We are trying to stand up a new web server with CF5/IIS5/WIN2K During the process of locking the server permissions/users down. We deleted the IWAM_servername and set up another account with the permissions we thought were needed. WE reviewed all the mapped directories/sites in IIS and changed the log on to the new account and reviewed all the services to also make sure the old account was not in use. But we are still getting the error that the old account is trying to long on and for obvious reasons is being denied access. We re-reviewed everything again and can find what is trying to log on using this account. The error acures with any site we try to run. part of the error is access is being denied to "/LM/W3SVC/1/ROOT", which should be the mapping to the first IIS web site or "/LM/W3SVC/1/ROOT/CFIDE? which would be the mapping to coldfusion admin. Can anyone think of a "hidden" or hard to find service or object that might be trying to use this The old IWAM account. THanks for any help __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists