That and you may want to look into PreserveSingleQuotes()
-----Original Message-----
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 2:49 AM
To: CF-Talk
Subject: RE: Help! Inserting WDDX into the database
I think you are missing a closing parenthisis: '#tempWddxData2#'
)
</cfquery>
Pascal
-----Oorspronkelijk bericht-----
Van: Brook Davies [mailto:[EMAIL PROTECTED]
Verzonden: do 18/09/2003 22:37
Aan: CF-Talk
CC:
Onderwerp: Help! Inserting WDDX into the database
I have a WDDX packet that, no matter what I try, generates an error
when I
try to insert it into a SQL 7.0 DB. Any ideas?
My Query looks like this:
<cfwddx input="#tempWddxData#" output="tempWddxData2"
action="cfml2wddx">
<!--- add a new member to an existing pool --->
<cfquery datasource="#request.datasource#" name="AddMember">
insert into LeadDistr_members (
usr_id,
form_id,
LeadDistrID,
member_name,
priority,
wddxdata
)
values
(
<cfqueryparam cfsqltype="cf_sql_integer"
value="#getmembers.usr_id#">,
<cfqueryparam cfsqltype="cf_sql_integer"
value="#getmembers.form_id#">,
<cfqueryparam cfsqltype="cf_sql_integer"
value="#newprofileID#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#getmembers.member_name#">,
<cfqueryparam cfsqltype="cf_sql_integer"
value="#getmembers.priority#">,
'#tempWddxData2#'
</cfquery>
I end up with an error like the one below. Also below is the
outputted SQL
Statement from the debugger:
============================================================================
==============
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 16: Incorrect
syntax
near 'City
============================================================================
==============
SQL insert into LeadDistr_members ( usr_id, form_id, LeadDistrID,
member_name, priority, wddxdata ) values ( (param 1) , (param 2) ,
(param
3) , (param 4) , (param 5) , '<wddxPacket
version=''1.0''><header/><data><struct><var
name=''field1''><string>City</string></var><var
name=''field2''><string></string></var><var
name=''field3''><string></string></var><var
name=''value2''><string></string></var><var
name=''value3''><string></string></var><var
name=''value1''><string>asdfasdf</string></var></struct></data></wddxPacket>
'
============================================================================
==============
I've spent an hour trying everything I can think of. Now I am
stumped.
Brook Davies
At 04:08 PM 9/18/2003 -0400, you wrote:
> > <CFSET Temp = QuerySetCell(Session.Cart, "Amount",
> > "<CFOUTPUT>#Evaluate(Form.S4x6 * 3.95)#</CFOUTPUT>")>
>
>
>Rick:
>
>What are the CFOUTPUT tags doing in your CFSET tag? Shouldn't this
just be:
>
> <CFSET Temp = QuerySetCell(Session.Cart, "Amount",
> Evaluate(Form.S4x6 *
>3.95))>
>
>My guess is that your SESSION.cart.amount variable is really equal
to:
>
> <CFOUTPUT>11.85</CFOUTPUT>
>
>and when that string gets spat out to the browser in the error
message, your
>browser is hiding the CFOUTPUT tags because it assumes they are
HTML tags
>that it is unfamiliar with. Check the HTML source code.
>
>--
>Mosh Teitelbaum
>evoch, LLC
>Tel: (301) 942-5378
>Fax: (301) 933-3651
>Email: [EMAIL PROTECTED]
>WWW: http://www.evoch.com/
>
>
> > -----Original Message-----
> > From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, September 18, 2003 3:39 PM
> > To: CF-Talk
> > Subject: Can anyone explain why this code is behaving like it
is?
> >
> >
> > This stuff is driving me crazy! All day spent to get almost
nowhere...
> >
> > Anyway...(deep breath)...
> >
> > Quick question: Does taking a number from a formfield and
putting it into
> > a "session.cart.amount" variable automatically turn it into a
string
> > variable?
> >
> > I'm sending a number from a formfield and in testing the amount
from the
> > formfield,
> > I can multiply it, format it using DollarFormat, etc... behaves
like a
> > number should.
> >
> > But once the formfield variable is placed in the Session Query
as
> > session.cart.amount,
> > it behaves like a string...I can't use DollarFormat...it returns
an error
> > that the variable session.cart.amount
> > has to be a number...if I use
DollarFormat(Val(session.cart.amount)), the
> > value of the variable is 0...zero...
> > it becomes a valueless string...
> >
> > I've haven't worked with the "session-type" queries created with
> > Session.Cart = QueryNew etc., before
> > and I guess I'm missing something...this should be simple
stuff...but...
> >
> > If anyone has any suggestions about why this is going on, I'd be
grateful
> > for the help...
> >
> > Rick
> >
> >
> > Excerpts from the code:
> >
> > The formfield:
> >
> > <SELECT Name="S4x6" Class="TextInput01">
> >
> > <Option Value="0" Selected>0</Option>
> > <Option Value="1">1</Option>
> > <Option Value="2">2</Option>
> > <Option Value="3">3</Option>
> > <Option Value="4">4</Option>
> > <Option Value="5">5</Option>
> > <Option Value="6">6</Option>
> > <Option Value="7">7</Option>
> > <Option Value="8">8</Option>
> > <Option Value="9">9</Option>
> > <Option Value="10">10</Option>
> >
> > </SELECT>
> >
> >
> >
> > Sent to another page for processing:
> >
> >
> >
> > <CFLOCK Scope="Session" Type="Exclusive" TimeOut="5">
> >
> > <CFSET Session.Total = 0>
> >
> > <CFIF Form.S4x6 is not "0">
> >
> > <CFSET Temp = QueryAddRow(Session.Cart)>
> > <CFSET Temp = QuerySetCell(Session.Cart, "PhotoFileName",
> > "<CFOUTPUT>#Form.PhotoFileName#</CFOUTPUT>")>
> > <CFSET Temp = QuerySetCell(Session.Cart, "Quantity",
> > "<CFOUTPUT>#Form.S4x6#</CFOUTPUT>")>
> > <CFSET Temp = QuerySetCell(Session.Cart, "Size", "4 x 6")>
> > <CFSET Temp = QuerySetCell(Session.Cart, "Amount",
> > "<CFOUTPUT>#Evaluate(Form.S4x6 * 3.95)#</CFOUTPUT>")>
> >
> > <CFOUTPUT>#DollarFormat(Session.Cart.Amount)#</CFOUTPUT><br>
> >
> >
> > -----------------Note: CURRENTLY, ON THE LINE ABOVE, I GET THE
FOLLOWING
> > ERROR:
> >
> > Parameter 1 of function DollarFormat which is now "11.85" must
be a number
> >
> > I've tried using Val to create a number out of what must be a
string, but
> > that will create a variable with a value of 0 (zero)...
> >
> >
------------------------------------------------------------------
> > ----------
> > -------------------------------------------------------
> >
> > </CFIF>
> >
> > <CFLOOP Query="Session.Cart">
> >
> > <CFOUTPUT>
> > PhotoFileName: #PhotoFileName#
> > Quantity: #Quantity#
> > Size: #Size#
> > Amount: #DollarFormat(Amount)#
> > </CFOUTPUT>
> >
> > <CFOUTPUT>#DollarFormat(Amount)#</CFOUTPUT>
> >
> > <CFSET Session.Total =
Evaluate(Session.Total+Session.Cart.Amount)>
> >
> > </CFLOOP>
> > <br><br>
> >
> > Order Total:
<CFOUTPUT>#DollarFormat(Session.Cart.Amount)#</CFOUTPUT>
> >
> > </CFLOCK>
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137655
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
