RE: Parsing text containing CF tags
Thanks philip. I appreciate it. --- Philip Arnold - ASP <[EMAIL PROTECTED]> wrote: > > I would appreciate your help on the following > question. > > Is there a way to parse text containing CF tags > without > > the tag being interpreted by the server? > > What I am trying to do is generate a query > dynamically > > by writting it to a text file. Then read the query > > from the text to a variable to include it in to a > cfm > > template to do the database query. > > While at it, you can give me a suggestion if there > is > > any other better way of doing the dynamic query > > generation instead of witting it first to a text > file. > > CF won't evaluate tags from a variable - it can > evaluate the contents of a > tag (or parameters of tags) from variables > > If it's only a query, then you could quite happily; > datasource="myDSN">#PreserveSingleQuotes(mySQL)# > > It's only if there are tags around it that become > dynamic, then I'd say to > put them in CFIFs rather than write to a file, and > hope the OS has written > it by the time you CFInclude it > > 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
Parsing text containing CF tags
I would appreciate your help on the following question. Is there a way to parse text containing CF tags without the tag being interpreted by the server? What I am trying to do is generate a query dynamically by writting it to a text file. Then read the query from the text to a variable to include it in to a cfm template to do the database query. While at it, you can give me a suggestion if there is any other better way of doing the dynamic query generation instead of witting it first to a text file. ~~ 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: Null Values
There is no IsNull function in Coldfusion. However,It helps to know that NULL is neither numeric nor anything. Try the IsNumeric function. It might do the job for you. Girmawi --- "Corina S. Moore" <[EMAIL PROTECTED]> wrote: > One quick question, > > I thought that there was a function called > IsNull() however whenever I > try to use it > gives me an error of "There is no ColdFusion > function named IsNull". > I am running 4.0 but have looked in both 4.0 and > 4.5 documentation and > have found anything one > it. Can someone Clear this up for me? > > Thank You > > Cori > > > > > 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] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ 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]
"cfhttp connection failure" error
Selam, I can't figure out why the cfhttp tag keeps giving me the "connection failure" error. I am trying to download a file from another site. It worked for me briefly once. I even tried higher requesttimeout?? to no avail. What's strange is small part of the file is downloaded before the connection failure. Nothing changed on the server. If you guys don't have the solution I am going to resort to a perl cgi call to do the job. Thank you, __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! Cold Fusion error and Oracle!
I recommend you capitalize all the column names in oracle. The error could be because of the mixed case in"newsID". Either put the newsID column in single quotes or make it uniform. --- Larry Juncker <[EMAIL PROTECTED]> wrote: > Check the case of your column names. I did that > yesterday and just because > I had one of the column names capitalized, my query > would not run properly. > > Larry Juncker > Senior Cold Fusion Programmer > Heartland Internet > > -Original Message- > From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 02, 2000 8:29 PM > To: CF-Talk > Subject: Help! Cold Fusion error and Oracle! > > > Hi all, > > I have a site that was built using an Access > database. I'm trying to use an > Oracle database instead but keep getting this error > message: > > Error Diagnostic Information > Oracle Error Code = 904 > > ORA-00904: invalid column name > > > > Data Source = "847_bib" > > SQL = "SELECT headline, news, blurb, date_entered, > newsID, live FROM news > WHERE (live = yes) ORDER by date_entered DESC" > > > The error occurred while processing an element with > a general identifier of > (CFQUERY), occupying document position (5:1) to > (5:56) in the template file > D:\INETPUB\WWWROOT\HEADLINECOVER.CFM > > I had an Oracle guy create the database for me, and > that seems fine, buy my > Cold Fusion pages are now in error. What the heck is > invalid column name? > > THis is the page in question (headlinecover.cfm): > > > DATASOURCE="#application.DSN#" > > SELECT headline, news, blurb, date_entered, > newsID, live > FROM news > WHERE (live = yes) > > ORDER by date_entered DESC > > > > > > > > > > > > > > > > > MAXROWS="5"> > > color="##cc"> href="news.cfm">#headline# > size="1" > color="black">#blurb# > > href="news.cfm">More news... > > > Thanks!!! > > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.