RE: Strange MYsql Error

2003-07-09 Thread Matt Robertson 
I personally always use the cfsqltype CF_SQL_Numeric for everything in
mySQL, although all of my fields tend to be just plain type int() (id
fields are 'unsigned').  Maybe switching to that would help?  Also I
don't use the maxlength parm.  No idea if that's got any bearing on your
problem, but its something you can throw against the wall and see what
comes back.

As an aside I found yesterday after a typo that mySQL will accept
cf_sql_varchar on numeric fields.  This one was an int(10) unsigned
primary key in a sql update.


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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

Strange MYsql Error

2003-07-09 Thread Jordan Thomas 
Hi,

I am using MYSQL as the DB for my app.

When I try to run the following  data is deleted from the
standard_attribute_value table but standard_attribute_value_translation is
left untouched. It throws no error but the data is still there. Actually,




   DELETE   standard_attribute_value_translation.*, standard_attribute_value.*
   FROM standard_attribute_value_translation savt, standard_attribute_value
sav
   WHEREsavt.standard_attribute_value_id_fk = sav.id
   AND  sav.standard_attribute_id_fk = 


I have checked the MySql log file and the query is being passed in OK but
there is a Sqare after the "this.id". I am not sure whether or not that
matters. I am also getting some strange problems when using the IN operator
not unlike this one. For instance:


DELETE
FROMstandard_attribute_value_translation
WHERE   standard_attribute_value_id_fk IN
(#valueList(qGetAttributeValue.id)#)


This also doesn't delete any rows although
"valueList(qGetAttributeValue.id)" is equal to "1,2,3" which corresponds to
records in the table.

Strange thing is that when I execute the query in a MYSQL client, it works
without a problem. Is this a problem with MySql, The MySql driver that comes
with CF or CF itself (although unlikely). Is this a common happening for
others?

Any ideas?

thanks

Jordan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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