numerics in the 'Where' clause

[Bill Schroyer]

You didn't say what type of error you are getting?

"SELECT * FROM [v_item_basic] WHERE
[v_item_basic.v_item_type_id] = 'v_item_type_iD'

Bill Schroyer
(e-mail address removed)
http://www.frontpagewiz.com

-----Original Message-----
I'm using fp2003 and sql server 2000

I want to create a dropdown box, populated dynamically

from a code table, then post it to a web page with a
database results area that displays records from a main
table based on the code table item choosen. Pretty
standard stuff right?

I can get all of these functions to work except when I

have a numeric field in the 'where' clause.

eg: the sql stmt in the 'results' screen...

this works...
select *
from v_item_basic
where v_item_basic.v_item_name=::v_item_name::

this doesn't...
select *
from v_item_basic
where v_item_basic.v_item_type_id=::v_item_type_iD::

the only difference seems to be the numeric v_item_id vs

the char v_item_name. Is there a numeric variable
indicator that is used rather than the double colon. I've
worked on this for some time now trying to create and
manipulate strings, ltrim-ing, and rtrim-ing my brains out.