RE: Looping Next Previous Buttons
Might want to look into formatting all of your date variables with the
CREATEODBCDATE function. I ran into a similar problem with dates. Worth a
try...
-Original Message-
From: Yvette Ingram [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 6:09 PM
To: CF-Talk
Subject: Looping Next Previous Buttons
Hi:
I'm building a scheduler that only shows a week at a glance (horizontally)
and time slots (vertically). When a user presses the Next button, I can
only get it to go to the next week and no further. Same thing with the
Previous button. Here's some code snipplets. My brain is fried at the
moment. Any help on this is greatly appreciated.
!--- set some variables ---
CFPARAM NAME="CurrentDate" DEFAULT="#now()#"
CFPARAM NAME="CurrentYear" DEFAULT="#Year(CurrentDate)#"
CFPARAM NAME="CurrentMonth" DEFAULT="#Month(CurrentDate)#"
CFPARAM NAME="CurrentDay" DEFAULT="#Day(CurrentDate)#"
CFPARAM NAME="Form.WeekChange" DEFAULT=""
!--- sets the start, end and maximum number of weeks ---
CFSET STARTWEEK = CURRENTDATE
CFSET ENDWEEK = CURRENTDATE + 6
CFSET MAXWEEK = CREATEODBCDATE(DATEADD('WW', 4, NOW()))
!--- stuff to handle the form --- (Problem Area I think)
CFIF ISDEFINED("Form.WeekChange")
CFIF FORM.WEEKCHANGE IS 'NEXT'
CFSET STARTWEEK = ENDWEEK + 1
CFSET ENDWEEK = STARTWEEK + 6
/CFIF
/CFIF
!--- output ---
!--- Week At A Glance ---
TR
CFOUTPUT
CFLOOP INDEX="current_week" FROM="#startweek#" TO="#endweek#"
#DateFormat(current_week, ',DD,')#
/TD
/CFLOOP
/CFOUTPUT
/TR
Yvette Ingram
Email: ingramrecruiting@erols or
[EMAIL PROTECTED]
ICQ: 21200397
~~
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: Databases
Where are you keeping your application.cfm? What directory? -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 3:34 AM To: CF-Talk Subject: Databases Hi All, We have two ODBC connctions one is to the Test DB (ocsdb_test) and other is to the live DB (ocsdb_live). In my Application.cfm I have a variable set up to look at the relevant source, When I'm testing amendments before placing them in the live system, occaisonally I pick up data from the live system, and clients are occaisionally updating the test Database. When I check the Server Logs, I notice the following message in the Application.log, this is also happening with Sites. More than one data source used in a CFTRANSACTION The use of multiple data sources (or multiple username/password attributes for a single data source) within a CFTRANSACTION is not permitted. You have attempted to submit an SQL statement to the data source 'OCSDB_LIVE' while you have a transaction open for the data source 'OCSDB_TEST'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (79:7) to (79:94)./pPPDate/Time: 02/21/01 11:05:48 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)BRRemote Address: 200.10.5.2 HTTP Referer: nxhqocs.nationalexpress.co.uk/ocs/main/OCS_Main.cfm?Departed=0" This is from a live client, The Test system is so theres no chance of it picking up the Application.cfm from the test directory. nxhqocs.nationalexpress.co.uk/ocstest/main/OCS_Main.cfm?Departed=0" All advice and help will be appreciated. As a tempory measure I've removed the ODBC connector to the TEST Database. Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [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: Passing values to Flash
Check out this site: -Original Message- From: John Dowdell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:37 PM To: CF-Talk Subject: Re: Passing values to Flash At 7:57 PM 2/13/1, Kinley Pon wrote: Is there a way to pass or set values to variables within a flash clip for example if I set the GET URL as www.blabblah.com/index.cfm?fuseaction=loginloginID=#LoginID#password=#pas s word#. I'm just getting up to speed in this particular area myself (so apologies in advance if I say something dumb ;-), but in this case the URL with its CF properties would not be available in the text file which ColdFusion processes on the server. (Rephrased, that dynamic address is embedded in the SWF, inaccessible to ColdFusion. The Macromedia Flash Player would send the literal "#LoginID#" phrase to the server, which could likely not be processed as part of an address.) What you *could* do would be to dynamically construct the complete URL query within the SWF file, and then submit these to the server... there wouldn't be a CF-level term like "#LoginID#" within this SWF movie, but you could certainly have a Flash-level textfield named "loginField" and pass its value along in the URL. Does this help at all in that project there, or am I focusing on something different than what you're trying to achieve...? I purchased 5 different books on flash 4 and none of them mentions how I can pass a variable or value into the flash clip before it starts playing. A lot depends on where the information comes from, and at which point you wish to access it. If the trigger is some user action within the SWF file, then we can request either remote URL-encoded text via a LoadVariables call, or XML-formatted data through the XML connectivity. If you're instead trying to pass data in when the file is delivered, then the following article has an overview of various methods: "Different approaches to setting variables in a Macromedia Flash movie" http://www.macromedia.com/go/14253 jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ 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: Passing values to Flash
http://www.blue-pac.com/products/aspturbine/default.htm -Original Message- From: John Dowdell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:37 PM To: CF-Talk Subject: Re: Passing values to Flash At 7:57 PM 2/13/1, Kinley Pon wrote: Is there a way to pass or set values to variables within a flash clip for example if I set the GET URL as www.blabblah.com/index.cfm?fuseaction=loginloginID=#LoginID#password=#pas s word#. I'm just getting up to speed in this particular area myself (so apologies in advance if I say something dumb ;-), but in this case the URL with its CF properties would not be available in the text file which ColdFusion processes on the server. (Rephrased, that dynamic address is embedded in the SWF, inaccessible to ColdFusion. The Macromedia Flash Player would send the literal "#LoginID#" phrase to the server, which could likely not be processed as part of an address.) What you *could* do would be to dynamically construct the complete URL query within the SWF file, and then submit these to the server... there wouldn't be a CF-level term like "#LoginID#" within this SWF movie, but you could certainly have a Flash-level textfield named "loginField" and pass its value along in the URL. Does this help at all in that project there, or am I focusing on something different than what you're trying to achieve...? I purchased 5 different books on flash 4 and none of them mentions how I can pass a variable or value into the flash clip before it starts playing. A lot depends on where the information comes from, and at which point you wish to access it. If the trigger is some user action within the SWF file, then we can request either remote URL-encoded text via a LoadVariables call, or XML-formatted data through the XML connectivity. If you're instead trying to pass data in when the file is delivered, then the following article has an overview of various methods: "Different approaches to setting variables in a Macromedia Flash movie" http://www.macromedia.com/go/14253 jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ 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: Replace List Help - SORRY
Dont you need to include "ALL" for it to replace all strings in the message?
Otherwise it just replaces the first found.
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 11, 2001 7:41 PM
To: CF-Talk
Subject: Re: Replace List Help - SORRY
Okay - sounds strange... have you tried removing the space after the commas
in
the list (remember the space will become part of the string to match).
As far as building them dynamically, try using the valuelist function - once
for
the things to replace, once for the replacements.
David
Erika Foster wrote:
Sorry about that last message - kids playing with the keyboard.
Can someone tell me why this doesn't work?
#ReplaceList(ParagraphFormat(message), ":-), :'(", "img
src=images/smiley.gif, img src=images/sad.gif")#
It works for the first replacement, but not for subsequent replacements in
the list. Also - I have the text and the images to replace the texts in a
DB table. I'd like to be able to build this ReplaceList function
dynamically. Any suggestions?
Thanks!
Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
String Formating
I have a form which I am dumping into a database. I need to keep the formatting that was used when submitting form (line breaks and spaces). What I would like to do is replace spaces and breaks with "nbsp;" and "br" How do I replace line breaks with a br? By the way, I dont want to use pre/pre to format the text. ~~ 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
Finding last record
I am inserting a record into one of my tables in MS Access. I want to then find the primary key(auto number) immediately after insertion. Is there an easy way to find it? Thanks, Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: images stop loading?
Are you hosting off of cable? I know some carriers suggest that there is above 70% free resources on the server for files (images) to be transfered efficeintly. Chad -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 4:08 PM To: CF-Talk Subject: RE: images stop loading? Thanks, but in my case I've been clearing the browser cache, and I'm running NT with 256 MB of RAM, over a cable modem. And many people have been seeing the problem, not just me, which makes me wonder if there's something on the server end, or something bizarre in the code. Any other ideas? Check the web-server config, it may be trying to serve the images badly - I find it happens on sites where there's a lot of traffic and their server isn't configured correctly... then again, mine probably isn't optimized g Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Multiple Select Lists
use cfloop to go through the list to get the selected values -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 06, 2001 6:56 AM To: CF-Talk Subject: RE: Multiple Select Lists Check out the ListContainsNoCase()function. I believe that this may do it for you: cfif ListContainsNoCase(mylist, optionvalue) selected/cfif Try to avoid ListContains unless you MUST use it - an example of why to use ListFind instead is; If you have product IDs that run from 1 to 100, and have them all on checkboxes on a page, using ListContains on the value "1" will return 1, 10, 11, etc. etc. Using ListFind only returns it if the list entry is the same as the item you're looking for Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Which message-board to get
Sounds like something you could do in either ASP or CF. CF development time will be quicker. Doenst sound too big if you are using an Access DB. Go with CF my choice of languages :-) -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 6:19 PM To: CF-Talk Subject: Which message-board to get Hi, I'm in a rut trying to decide what I need for my site. I urgently need to add some user-interaction in the form of message boards, or a BBS - but it needs to be expandable and customisable, not to mention Access-accessible :) I want to be able to have different parts of the site available for "discussion." For example; they might want to discuss a product, in which case, that particular product would later be flagged as "in discussion." I don't know of any software that is really elasticated enough. I don't like the Perl-based one either, as I find them harder to integrate into my code. Can anyone advise? Thanks Will ~~ 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: CFFILE UPLOAD
I had the same problem before... couldn't figure it out. Ran into the same problem with some complex queries. After exhausting all of my known possibilities... I reinstalled CF Server and everything worked fine. Haven't had any problems since. Chad -Original Message- From: Sim Graves [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 11:02 AM To: CF-Talk Subject: CFFILE UPLOAD We're running CF4.5 NTserver 4.0 SP6 (don't say it, I know SP6=Bad). When we use CFFILE to upload a file, the file increases the size of coldfusion.exe and never decreases, even after the file is written to the disk. After a few uploads all of our 500megs of RAM is gone. At the Allaire forum all I could find was a suggestion to drop CFFILE and use PERL. This can't be the only solution (I hope). Any suggestions will be greatly appreciated. Sincerely, Sim Graves Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: search query help
Since you are using the 'OR' condition, the keyword does not have to be in the results for news.article (it can be in subtitle, title, keywords or dated). Try writing it his way cfquery name="news" datasource="mydsn" select news.title, news.subtitle, news.dated, news.id, news.article fromnews where news.complete = 1 and news.article like '#form.keywords#%' ---AND news.subtitle like '#form.keywords#%' or news.title like '#form.keywords#%' or news.keywords like '#form.keywords#%' order bynews.dated desc /cfquery Another possibility are you sure that your keyword appears in the article field? May sound like a stupid question but worth looking at. Hope that I am not missing something in your question... Chad -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 31, 2000 9:51 PM To: CF-Talk Subject: search query help Hi all, I have this simple search query that's perplexing me somewhat. cfquery name="news" datasource="mydsn" select news.title, news.subtitle, news.dated, news.id, news.article fromnews where news.complete = 1 and news.article like '#form.keywords#%' or news.subtitle like '#form.keywords#%' or news.title like '#form.keywords#%' or news.keywords like '#form.keywords#%' order bynews.dated desc /cfquery I've tried it a million different ways (well almost :) ) - this seems logical to me but it's not finding text that only appears in the news.article field. What am I missing? Regards, K. __ Kay Smoljak - HTML/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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFFile
If a file with the same name already exists on the server, you can use a NAMECONFLICT="makeunique". But what I want to know is if there is a way to see if it already exists on the server, and then prompt the user to rename the file, instead of CF handling this issue? Thanks, Chad -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 1:47 AM To: CF-Talk Subject: Re: CFFile How do I get the name of a file after it has been uploaded by a user using cffile? See the documentation for CFFILE with action="Upload". There are a whole slew of results variables, prefixed with 'file.', that give you the results of an upload. The one that gives the filename on your server is 'file.ServerFile'. Jim Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF-Talk enhancement (possibly)
I think it would be a good addition to the list. I also like the feature of putting the name of the user group in the subject line. Another group I belong to does this. For example, put [CF-Talk] at the beginning of the subject of all messages. This helps sorting CF e-mails from others. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 28, 2000 5:16 PM To: CF-Talk Subject: CF-Talk enhancement (possibly) This is mainly to Michael D, but I thought some other feedback from others might help with the issue... I don't know about the rest of you, but I get (slighly) annoyed with the messages with no subject - especially when there are several in a day, and the replies are all "Re:" in the subject So, what I am suggesting (if it's possible Michael...) is that if a non-subject message comes in, it's automatically given a subject, similar to those "CF-Talk V1 #n" messages... if Michael is feeling particularly nasty, then something like "Lazy person who couldn't be bothered typing a Subject #43" (heh, only kidding) At least that way, we can find the replies easier than hunting through 20 messages with no title and the 60-70 replies which don't follow - especially when you put your CF-Talk folder into Subject Order Comments? Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE:
www.cfhosting.com -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 7:32 AM To: CF-Talk Subject: Hi, I am looking for a top notch reliable cf hosting service I was originally with intermedia and then left due to slow response time and many posts on here speaking negatively of their service From there I moved to interland and found their service and response time far too slow in my opinion I an currently with logicworld and have experienced on 2 occasions in 4 days the server being down So I would like some suggestions on a top quality reliable and fast cf hosting service that has a proven track record handling very highly trafficked and medium sized cf application your comments would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Slightly OT: Cable Modem and IIS
I had @Home about a year ago, and I was running IIS. @Home does not allow you to do this, but I had my server running for about a year (they never found out about it). I was not hosting, but was using it for personal/development use. If you register the IP... you are risking it. Chad -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 2:43 PM To: CF-Talk Subject: Re: Slightly OT: Cable Modem and TZO I don't know about TZO, but I have a small site on @home running from my own server. I think it's fine if you don't get too many hits. The bandwidth isn't very big but the speed is fine. tom - Original Message - From: "Debbie McDaniel" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, October 24, 2000 2:32 PM Subject: Slightly OT: Cable Modem and TZO Hi everyone, I am currently subscribed as a @Home (cable modem) user. I would like to host my own personal CF website (.com) on my own server. Has anyone ever heard of TZO? Is anyone hosting their own server using @Home (with or without TZO)? Thanks, Deb -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Running a Dynamically Created Query
I did a cfoutput to check and see what the query looked like before running it on SQL Server. ... UserID=1 and GroupID=56 and City = 'Atlanta' . So I know that it has single quotes on it before executing the query. I have also made sure that all entries are trimmed. I have also used LIKE instead of =. Chad -Original Message- From: Nat Papovich [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 12:51 AM To: CF-Talk Subject: RE: Running a Dynamically Created Query The best, fastest thing to try would be to remove the cfquery tag and replace it with a cfoutput tag. That way, you can see exactly what is happening, and what all the variables are evaluating to. But maybe you've already done that... Are you using PreserveSingleQuotes()? Nat Papovich ICQ 32676414 "If it was hard to write," says the Real Programmer, "it should be hard to understand." -Original Message----- From: Chad Elley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2000 9:19 PM To: CF-Talk Subject: Running a Dynamically Created Query I have set up a series of Cold Fusion templates that build a dynamic SQL statement. I have run into a "stump in the road" as a result. The SQL statement consists almost entirely of variables equaling an integer, but when I have a variable equal to a string, I get errors. For example, when I attempt to drop a value enclosed in single quotes (i.e. city = 'Atlanta'), I get errors. Here is the problem though... We can copy the code into SQL server 2K and it runs perfectly, but when it executes it through Cold Fusion passing it into SQL server, it bombs out. Any suggestions? Thanks, Chad Elley Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Running a Dynamically Created Query
I have set up a series of Cold Fusion templates that build a dynamic SQL statement. I have run into a "stump in the road" as a result. The SQL statement consists almost entirely of variables equaling an integer, but when I have a variable equal to a string, I get errors. For example, when I attempt to drop a value enclosed in single quotes (i.e. city = 'Atlanta'), I get errors. Here is the problem though... We can copy the code into SQL server 2K and it runs perfectly, but when it executes it through Cold Fusion passing it into SQL server, it bombs out. Any suggestions? Thanks, Chad Elley Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: How to display Value and Label from listbox
Simplify it, CFLOOP QUERY="myQry" select name="region" option value="#myqry.email#" CFIF myqry.Country EQ "Africa"selected/cfif#myqry.Country# #myqry.email#/option /select /cfloop -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 8:55 AM To: CF-Talk Subject: RE: How to display Value and Label from listbox Les; If you are filling this list box with dynamically generated code, what about this? CFLOOP QUERY="myQry" select name="region" CFIF myqry.Country EQ "Africa" option value="#myqry.email#" selected#myqry.Country# #myqry.email#/option CFELSE option value="#myqry.email#"#myqry.Country# #myqry.email#/option /cfif /select /cfloop Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 7:08 PM To: CF-Talk Subject: How to display Value and Label from listbox Trying to figure out how to format output for a listbox on a form, such as below: select name="Region" option value="[EMAIL PROTECTED]" selectedAfrica/option option value="[EMAIL PROTECTED]"Asia amp; Pacific/option option value="[EMAIL PROTECTED]"Eastern South America/option /select On the action page, I can easily get the value to come up CFOUTPUT #Region# /CFOUTPUT However, I need BOTH the value, and the Item Label to display, like: Region Email Africa [EMAIL PROTECTED] For processing purposes, I'm ONLY using the value (the email address) but for display purposes, and since there's close to 50 regions in the list, I need to see the label as well so the client will know if they selected the right region or not. That make any sense? Thanks! Les Mizzell *** Some people say I'm too apathetic. But why should I care? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
