Thanks. That's exactly what I'm looking to do, and will test. Much appreciated!
And I guess I better learn to explain myself better. : )
Joel
"Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
: > I have a table with a varchar field named catid. When a url variable named
: > catid is passed, the page grabs all the data for that specific
: > catid. Simple stuff.
: >
: > My problem lies in now I need for the catid to be a list
: > (2,5,56,89). Thus the
: > varchar field, and not a numeric. How can I select those items
: > that contain
: > the correct url.catid? I tried the IN keyword, with no success.
:
: If I've got this the right way round - the CatID in the database contains
: the list, and the user only passes one ID, right?
:
: If that's the case, then you're going to have to do one of 2 thinks;
: Use InStr/CharIndex to find the character
: Use Like
:
: The problems with this is that if you look for smaller digits than the
: larger ones (like looking for 1) then it'll find it in things like 1, 10,
: 11, 21 etc. etc.
: The way around this is to look for the number with commas around it - but
: you've got to add commas to the start and end of the field when you're
: looking, so;
:
: Select *
: from myTable
: where CharIndex(',#URL.CatID#,', ',' + CatID + ',') > 0
:
: CharIndex is the SQL Server version, if you're using Access, then it's
: InStr, and the parameters are round the other way
:
: With Like, you'd do;
:
: Select *
: from myTable
: where ',' + CatID + ',' Like '%,#URL.CatID#,%'
:
: But I haven't tried this, so it may not work
:
: Also note that Access uses & instead of + for string concatonation
:
: HTH
:
: Philip Arnold
: ASP Multimedia Limited
: T: +44 (0)20 8680 1133
:
: "Websites for the real world"
:
: **********************************************************************
: This email and any files transmitted with it are confidential and
: intended solely for the use of the individual or entity to whom they
: are addressed. If you have received this email in error please notify
: the system manager.
: **********************************************************************
:
:
: ------------------------------------------------------------------------------
: Archives: http://www.eGroups.com/list/cf-talk
: 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.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
