The database design is not conducive to what you are trying to do. The
column should be of decimal type where the number represents the length. So
3/4 would be in the DB as .75
I don't believe there is a way to do what you are trying to do with SQL.
+-----------------------------------------------+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 10:17 AM
To: CF-Talk
Subject: SQL Question...
In my db I've got a varchar column called 'width'.
It has values like 3/4" or 5/8", etc.
I'd like to write a where clause in a SQL query that does
something like this:
WHERE 0=0
AND (WIDTH BETWEEN #FORM.Width1# AND #FORM.Width2#)
[i.e. -- (AND (0.75 BETWEEN 0.5 AND 1))]
What do I need to do to make this work? Covert? Cast?
Che Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
