Select Question

[siriiven]

Say I am passing a variable through a drop down select menu to the next page and the output looks like this HB54Htg1. It is actually two variables #location##controller#. The left 4 character will always be the building code. Whatever comes after is always the controller name. I need to query to get a serial number based on what the building is and what the controller is.

I'm having trouble writing a select statement that is something like:

Select SN from inventory
where location.inventory = '#left(form.controller, 4)#' and Controller.inventory = The rest of the string after the left 4 characters.

Can anyone help me out?

[Newsgroup_User]

...
and Controller.inventory = '#right(form.controller, len(form.controller)
- 4)#'

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[Newsgroup_User]

shouldn't they be inventory.location and inventory.Controller instead?

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[Guest]

Try this:

<cfset passedInString = "HB45aks93020" />
<cfset location = Left(passedInString, 4) />
<cfset controller = Mid(passedInString, 5, Len(passedInString)) />

<cfoutput>
#location# -- #controller#
</cfoutput>