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; cfquery datasource="myDSN"#PreserveSingleQuotes(mySQL)#/cfquery 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=listsbody=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):
!--- query database for information ---
CFQUERY NAME="GetNews"
DATASOURCE="#application.DSN#"
SELECT headline, news, blurb, date_entered,
newsID, live
FROM news
WHERE (live = yes)
ORDER by date_entered DESC
/CFQUERY
!-- If the user access this page for the first
time, we set the_start
value at 1 --
CFPARAM NAME="the_start" DEFAULT="1"
!-- If the the_start is already defined,
then we had 5 to it to calculate the value of
next_start --
CFIF IsDefined("the_start")
CFSET next_start = #the_start# + 3
/CFIF
!--- Output Querry ---
CFOUTPUT query="GetNews" STARTROW="#the_start#"
MAXROWS="5"
bfont face="Verdana, Arial, Helvetica,
sans-serif" size="1"
color="##cc"a
href="news.cfm"#headline#/a/font/bbr
font face="Verdana, Arial, Helvetica, sans-serif"
size="1"
color="black"#blurb#/fontbrbr /CFOUTPUT
bfont face="Verdana, Arial, Helvetica,
sans-serif" size="1"a
href="news.cfm"More news.../a/font/b
Thanks!!!
--
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.
__
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=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
