We are having problems writing to Foxpro dbc tables for numeric or integer
values with remote CF-based SQL queries. CF reports a data type mismatch.
We have tried many procedures, such as: retrieving integer data as a string,
converting to numeric with CF [NumberFormat(), Val(), or ParseNumber()]
incrementing while setting a new variable name [retrieval + 1 or
IncrementValue()], testing the result [IsNumeric()] for conditional display
(*always successful*), and then committing the results -- both with and
without various single or nested SQL functions appended to the query
[int(#variable#) or val(int(#variable#)) for integer and numeric fields
respectively, for instance].
No combination has thus far returned a single successful query write.
Anyone taken on Foxpro sources?
Paul Davies
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
