MSAccess query : detect data type

[Conti]

"deleteID" in the following query could be either alpha or numeric.
How to modify the query to accomodate both cases?

<CFQUERY datasource="#dsn#">
delete from #table#
Where #deleteID#='#Evaluate(deleteID)#'
</CFQUERY>

ThankYou

[jdeline]

You could do something like the code below. If the first delete throws an
error, the second delete (without the quote marks) will execute.



<CFTRY>
<CFQUERY datasource="#dsn#">
delete from #table# Where #deleteID#='#Evaluate(deleteID)#'
</CFQUERY>
<CFCATCH
<CFQUERY datasource="#dsn#">
delete from #table# Where #deleteID#=#Evaluate(deleteID)#
</CFQUERY>
</CFCATCH>

[GreatBlue]

I have the same issue but I have several fields and I need to know if they are
numeric, date, or text data types. I can test the data, but I need to know
what type of field is in the database column.

Is there a way to test for the ODBC table columns data type in MS Access and
SQL Server?

Thanks.

[mxstu]

Conti,

What kind of variables are #table# and #deleteID#? If they are not local
variables and are URL or FORM variables instead, this is a potentially
dangerous query. If the page containing this code has poor security, your user
could access the page directly and potentially delete information from your
tables. There is also sql injection to think about.