Current location: Hot Scripts Forums » Programming Languages » ASP » Invalid procedure call or argument: 'Left'


Invalid procedure call or argument: 'Left'

Reply
  #1 (permalink)  
Old 01-14-04, 01:51 AM
kryptoMatic kryptoMatic is offline
New Member
 
Join Date: Jan 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Invalid procedure call or argument: 'Left'

Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'Left' at the line:
strInList = Left(strInList, len(strInList)-1)

any ideas?

Dim arrCuisines, strInList

arrCuisines = array("AFRICAN","CARIBBEAN","CHINESE","CONTINENTAL ",....")

For each cuisine In arrCuisines
If Request.Form(cuisine) = "true" Then
strInList = strInList & "'" & cuisine & "',"
End If
Next

strInList = Left(strInList, len(strInList)-1)

sql = "SELECT * FROM logbook WHERE cusine IN (" & strInList & ")"

Last edited by kryptoMatic; 01-14-04 at 02:00 AM.
Reply With Quote
  #2 (permalink)  
Old 01-14-04, 05:35 PM
Stealth Stealth is offline
1337 pr0gr4mm3r
 
Join Date: Jun 2003
Location: Glasgow, Scotland
Posts: 188
Thanks: 0
Thanked 0 Times in 0 Posts
strInList = Left(strInList, len(strInList - 1))
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump


All times are GMT -5. The time now is 04:05 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.