[flexcoders] Error executing database querry

2005-12-26 Thread vmlr123 
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_by#
')
/cfquery


Is it some thing related to the datasource settings..?








 Yahoo! Groups Sponsor ~-- 
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/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/

RE: [flexcoders] Error executing database querry

2005-12-26 Thread Tracy Spratt 
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: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of vmlr123
Sent: Monday, December 26, 2005 8:05 AM
To: flexcoders@yahoogroups.com
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_by#
')
/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 ~-- 
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/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/

Re: [flexcoders] Error executing database querry

2005-12-26 Thread Tariq Ahmed 
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: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of vmlr123
Sent: Monday, December 26, 2005 8:05 AM
To: flexcoders@yahoogroups.com
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_by#
')
   /cfquery


Is it some thing related to the datasource settings..?


  






 Yahoo! Groups Sponsor ~-- 
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/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/

RE: [flexcoders] Error executing database querry

2005-12-26 Thread Tracy Spratt 
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: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Tariq Ahmed
Sent: Monday, December 26, 2005 3:32 PM
To: flexcoders@yahoogroups.com
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: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of vmlr123
Sent: Monday, December 26, 2005 8:05 AM
To: flexcoders@yahoogroups.com
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_by#
')
   /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 ~-- 
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/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/