Yes, as you said the problem was with sql query.
for integer field i was parsing a value
('#arguments.brandToAdd.brand_id#') which was throwing error.
Also one more thing which should be noticed here is, for db2 it
doesnt take double quotes when you insert data. thank you
--- In [email protected], "Tracy Spratt" <[EMAIL PROTECTED]>
wrote:
>
> Yeah, if you can get CF to display or trace or log the final,
evaluated
> SQL string, you can copy that and try it directly against the
database
> using Query Analyzer or some other database query tool.
> Tracy
>
> -----Original Message-----
> From: [email protected]
[mailto:[EMAIL PROTECTED] On
> Behalf Of Tariq Ahmed
> Sent: Monday, December 26, 2005 3:32 PM
> To: [email protected]
> Subject: Re: [flexcoders] Error executing database querry
>
> One of the practices I've been using in Flex development using CF
is to
> build a function test page that can be used to test functions in
the
> CFC's that your Flex app will be calling. This makes it easier when
> debugging to verify if everything on the CF side is good and get
the
> detailed CF diagnostics when the function fails.
>
> Though SQL wise there could be a lot of things that could cause the
> stuff below to bomb. Eg if brand_id is an integer field the
> '#arguments.brandToAdd.brand_id#' is trying to pass a string to
that
> field. Likewise with created_by, and modified_by.
>
>
>
> Tracy Spratt wrote:
>
> >I don't do CF, but that error does not sound like it is related to
> flex.
> >
> >Can you get your cfquery to display in a normal browser page? Or
a cf
> >generated test page?
> >
> >Tracy
> >
> >-----Original Message-----
> >From: [email protected]
[mailto:[EMAIL PROTECTED] On
> >Behalf Of vmlr123
> >Sent: Monday, December 26, 2005 8:05 AM
> >To: [email protected]
> >Subject: [flexcoders] Error executing database querry
> >
> >Can any body just tell me why "Error executing database querry" .
> >Im new to flex and just trying to connect my db2 database with
flex
> >using coldfusion.
> >
> >I dont find any error in the sql querry im using.
> >
> ><cfquery datasource="DSFORCF">
> > INSERT INTO SPFLEX.M_BRAND_DETAILS
> >(brand_id,brand_name,created_by,modified_by)
> > VALUES
> >
('#arguments.brandToAdd.brand_id#','#arguments.brandToAdd.brand_name#'
,
>
>'#arguments.brandToAdd.created_by#','#arguments.brandToAdd.modified_b
y#
> >')
> > </cfquery>
> >
> >
> >Is it some thing related to the datasource settings..?
> >
> >
> >
> >
>
>
>
>
>
>
> --
> Flexcoders Mailing List
> FAQ:
http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
> Search Archives:
> http://www.mail-archive.com/flexcoders%40yahoogroups.com
> Yahoo! Groups Links
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
AIDS in India: A "lurking bomb." Click and help stop AIDS now.
http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/nhFolB/TM
--------------------------------------------------------------------~->
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
