the most obvious answer is to not write anything to the db until they have
confirmed all is correct. Just pass the form fields through to the next
page...
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 1:38 PM
To: CF-Talk
Subject: Mysterious second set of single quotes
I have a variable I build before inserting into my query called where
<cfset where = "#where##table#id = '#attributes.id#'">
Then I put into my query...
<cfquery name="search"
datasource="#session.datasource#">
SELECT t.id,t.product_name,t.operator,t.stage,t.qc_lot,r.s4_time,r.s5_time
FROM trip_data t, report_stamps r
WHERE t.id = r.id AND #where#
</cfquery>
If I output the variable before the query like so (line 2) I get t.id='100'
1. <cfset where = "#where##table#id = '#attributes.id#'">
2. <cfoutput>#where#</cfoutput><cfabort>
3. <cfquery name="search"
4. datasource="#session.datasource#">
5. SELECT
t.id,t.product_name,t.operator,t.stage,t.qc_lot,r.s4_time,r.s5_time
6. FROM trip_data t, report_stamps r
7. WHERE t.id = r.id AND #where#
8. </cfquery>
However when I ditch line 2 the query output has two single quotes
surrounding my variable.
EXAMPLE OUTPUT IN QUERY
1. SELECT t.id,t.product_name,t.operator,
2. t.stage,t.qc_lot,r.s4_time,r.s5_time
3. FROM trip_data t, report_stamps r
4. WHERE t.id = r.id AND t.id = ''100''
Notice line 4
Does anyone know why CFML adds this mysterious second set of single quotes
when I output within the cfquery tags?
Ray Bujarski
Direct 858-845-7669
Pager 858-636-9900
______________________________________________________________________
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
