Cfquery in mysql part 2

2003-01-17 Thread Ryan Mitchell 
Ok, so I got that, and a few others to work, now I have a bit of an issue
with my delete statements

cfquery 
DELETE * FROM PPD WHERE ID = #url.id#
/cfquery

Now I tried using cfqueryparam for the url.id but none worked! the field
type is tinyint(4)...

Help!!!
Ryan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfquery in mysql part 2

2003-01-17 Thread Todd 
Remove the asterisk.

~Todd

At 05:59 PM 1/17/2003 +, you wrote:
Ok, so I got that, and a few others to work, now I have a bit of an issue
with my delete statements

cfquery 
DELETE * FROM PPD WHERE ID = #url.id#
/cfquery

Now I tried using cfqueryparam for the url.id but none worked! the field
type is tinyint(4)...

Help!!!
Ryan




--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4