Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Graham Comley #1
SQL select in problem
Hi All
Using asp vbscript
I have used the SQL statement before where xxx in('yyy') on a numeric data
field and with a request. string yyy = 1,3,5,7 . All works fine but I
cannot get it to work on character data ie character field in the database
and string yyy= M, F, C. Is there a restriction with the in() function
within SQL that it only works on numeric data. Would appreciate any
guidance on this
Many thanks
Graham Comley Guest
-
Select Problem
Hi All, I have a column in my table with values like this: CBMON3.03122005 WESAT1.04262006 TRSAT3.01282006 .. .. .. -
Problem with NOT IN and Sub-Select
I have the following query SELECT vw_mail_add.contact_id, vw_mail_add.first_name, vw_mail_add.last_name, vw_mail_add.address1, vw_mail_add.add2,... -
problem with the select query
Hi people, this is my first mail to the group. i am having a problem with the select query. There are a few values in few columns of a table with... -
SELECT mit Parametern: Problem
Help, an alle, Bin ein Newbie in Perl. Habe eine Datenbank unter Visual Foxpro 6.0 genannt Patwin Unter Perl ActivePerl Win32 5.8.0806, Treiber... -
SQL select statement problem...
I'm not sure if this is possible or not, but this is what I would like to do is something like this: I have two tables. Table A has 4 rows (with... -
Lionstone #2 Re: SQL select in problem
No restriction. You just have to offset each string with quotes. If you
just say IN ('"&Request.Form("field")&"'), then all of your form fields are
in one giant string, like "1,2,3,4,5" instead of "1","2","3","4","5", which
is what IN expects.
Use:
.... IN ('"&Replace(Request.Form("field"),", ","', '")&"') ...
"Graham Comley" <grahamcomley@yahoo.co.uk> wrote in message
news:d6ks22$lge$1@forums.macromedia.com...> Hi All
> Using asp vbscript
> I have used the SQL statement before where xxx in('yyy') on a numeric
> data
> field and with a request. string yyy = 1,3,5,7 . All works fine but I
> cannot get it to work on character data ie character field in the
> database
> and string yyy= M, F, C. Is there a restriction with the in() function
> within SQL that it only works on numeric data. Would appreciate any
> guidance on this
> Many thanks
>
>
>
Lionstone Guest
-
Graham Comley #3 Re: SQL select in problem
Hi Lionstone
Many thanks for the information it worked a treat
Graham
Graham Comley Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
