p2p.wrox.com: Archives - asp_web

asp_web_howto thread: The conversion of the varchar value 'xxxxxx' overflowed an int column

Message #1 by "Joe" <joe@k...> on Tue, 26 Mar 2002 16:45:47

Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a simple 
script to export x amount of records to either Word, Excel or Print 
depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int 
column. Maximum integer value exceeded. 

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL ,
CatalogueNumberDescription [varchar] (500) NULL ,
DrawingNumber [int] NULL ,
Requester [varchar] (55) NULL ,
CatalogueNumberDate [smalldatetime] NULL 

The problem is with the field CatalogueNumber. In an ideal word I would 
use bigint as the datatype (see No above), but the table is part of a 
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray	= request.form("cbxRecord")

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN 
("&strArray&") " 

Can anyone shed some light on this? Have I missed something?

TIA

Joe

Message #2 by "TomMallard" <mallard@s...> on Tue, 26 Mar 2002 08:49:02 -0800

Have you tried using CStr()?

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CStr(CatalogueNumber) IN
("&strArray&") "

tom mallard
seattle
-----Original Message-----
From: Joe [mailto:joe@k...]
Sent: Tuesday, March 26, 2002 4:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] The conversion of the varchar value 'xxxxxx'
overflowed an int column


Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a simple
script to export x amount of records to either Word, Excel or Print
depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int
column. Maximum integer value exceeded.

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL ,
CatalogueNumberDescription [varchar] (500) NULL ,
DrawingNumber [int] NULL ,
Requester [varchar] (55) NULL ,
CatalogueNumberDate [smalldatetime] NULL

The problem is with the field CatalogueNumber. In an ideal word I would
use bigint as the datatype (see No above), but the table is part of a
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray	= request.form("cbxRecord")

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&strArray&") "

Can anyone shed some light on this? Have I missed something?

TIA

Joe

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20

Message #3 by Joe Ingle <Joe@k...> on Tue, 26 Mar 2002 16:55:54 -0000

Would that not be using CStr() in the wrong context?
I have tried:

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&CStr(strArray)&") "

But that doesn't work.

-----Original Message-----
From: TomMallard [mailto:mallard@s...]
Sent: Tuesday, March 26, 2002 4:49 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value
'xxxxxx' overflowed an int column


Have you tried using CStr()?

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CStr(CatalogueNumber) IN
("&strArray&") "

tom mallard
seattle
-----Original Message-----
From: Joe [mailto:joe@k...]
Sent: Tuesday, March 26, 2002 4:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] The conversion of the varchar value 'xxxxxx'
overflowed an int column


Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a simple
script to export x amount of records to either Word, Excel or Print
depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int
column. Maximum integer value exceeded.

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL ,
CatalogueNumberDescription [varchar] (500) NULL ,
DrawingNumber [int] NULL ,
Requester [varchar] (55) NULL ,
CatalogueNumberDate [smalldatetime] NULL

The problem is with the field CatalogueNumber. In an ideal word I would
use bigint as the datatype (see No above), but the table is part of a
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray	= request.form("cbxRecord")

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&strArray&") "

Can anyone shed some light on this? Have I missed something?

TIA

Joe

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20

Message #4 by william.sze@s... on Tue, 26 Mar 2002 11:55:15 -0500

Since CatalogueNumber is a vachar, try

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
('"&strArray&"') "




                                                                                                                   
                    Joe Ingle                                                                                      
                    <Joe@k...       To:     "ASP Web HowTo" <asp_web_howto@p...>                      
                    co.uk>               cc:                                                                       
                                         Subject:     [asp_web_howto] RE: The conversion of the varchar value      
                    03/26/2002            'xxxx     xx' overflowed an int column                                   
                    11:55 AM                                                                                       
                    Please respond                                                                                 
                    to "ASP Web                                                                                    
                    HowTo"                                                                                         
                                                                                                                   
                                                                                                                   




Would that not be using CStr() in the wrong context?
I have tried:

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&CStr(strArray)&") "

But that doesn't work.

-----Original Message-----
From: TomMallard [mailto:mallard@s...]
Sent: Tuesday, March 26, 2002 4:49 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value
'xxxxxx' overflowed an int column


Have you tried using CStr()?

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CStr(CatalogueNumber) IN
("&strArray&") "

tom mallard
seattle
-----Original Message-----
From: Joe [mailto:joe@k...]
Sent: Tuesday, March 26, 2002 4:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] The conversion of the varchar value 'xxxxxx'
overflowed an int column


Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a simple
script to export x amount of records to either Word, Excel or Print
depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int
column. Maximum integer value exceeded.

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL ,
CatalogueNumberDescription [varchar] (500) NULL ,
DrawingNumber [int] NULL ,
Requester [varchar] (55) NULL ,
CatalogueNumberDate [smalldatetime] NULL

The problem is with the field CatalogueNumber. In an ideal word I would
use bigint as the datatype (see No above), but the table is part of a
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray        = request.form("cbxRecord")

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&strArray&") "

Can anyone shed some light on this? Have I missed something?

TIA

Joe

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20

Message #5 by Joe Ingle <Joe@k...> on Tue, 26 Mar 2002 17:14:30 -0000

Hi William

I've tried that too!! Really, I'm at a loss. If I do a response.write to
trap the string on it's way in, It looks fine. i.e

3214234 , 341234 , 12341324 , 413341 , dsn2123

It's just not making sense!

Joe

-----Original Message-----
From: william.sze@s... [mailto:william.sze@s...]
Sent: Tuesday, March 26, 2002 4:55 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value 'xxxx
xx' overflowed an int column



Since CatalogueNumber is a vachar, try

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
('"&strArray&"') "




 

                    Joe Ingle

                    <Joe@k...       To:     "ASP Web HowTo"
<asp_web_howto@p...>                      
                    co.uk>               cc:

                                         Subject:     [asp_web_howto] RE:
The conversion of the varchar value      
                    03/26/2002            'xxxx     xx' overflowed an int
column                                   
                    11:55 AM

                    Please respond

                    to "ASP Web

                    HowTo"

 

 





Would that not be using CStr() in the wrong context?
I have tried:

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&CStr(strArray)&") "

But that doesn't work.

-----Original Message-----
From: TomMallard [mailto:mallard@s...]
Sent: Tuesday, March 26, 2002 4:49 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value
'xxxxxx' overflowed an int column


Have you tried using CStr()?

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CStr(CatalogueNumber) IN
("&strArray&") "

tom mallard
seattle
-----Original Message-----
From: Joe [mailto:joe@k...]
Sent: Tuesday, March 26, 2002 4:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] The conversion of the varchar value 'xxxxxx'
overflowed an int column


Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a simple
script to export x amount of records to either Word, Excel or Print
depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int
column. Maximum integer value exceeded.

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL ,
CatalogueNumberDescription [varchar] (500) NULL ,
DrawingNumber [int] NULL ,
Requester [varchar] (55) NULL ,
CatalogueNumberDate [smalldatetime] NULL

The problem is with the field CatalogueNumber. In an ideal word I would
use bigint as the datatype (see No above), but the table is part of a
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray        = request.form("cbxRecord")

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&strArray&") "

Can anyone shed some light on this? Have I missed something?

TIA

Joe

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20






---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20

Message #6 by Joe Ingle <Joe@k...> on Tue, 26 Mar 2002 17:46:17 -0000

Hi Guys

Solved!! 

At the checkbox side I'd put:
<INPUT TYPE="CHECKBOX" NAME="cbxRecord" VALUE="<%=objRs("Blah")%>">

should have been:

<INPUT TYPE="CHECKBOX" NAME="cbxRecord" VALUE="'<%=objRs("Blah")%>'">

Thanks for the tips.

Joe

-----Original Message-----
From: Joe Ingle [mailto:Joe@k...]
Sent: Tuesday, March 26, 2002 5:15 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value 'xxxx
xx' overflowed an int column


Hi William

I've tried that too!! Really, I'm at a loss. If I do a response.write to
trap the string on it's way in, It looks fine. i.e

3214234 , 341234 , 12341324 , 413341 , dsn2123

It's just not making sense!

Joe

-----Original Message-----
From: william.sze@s... [mailto:william.sze@s...]
Sent: Tuesday, March 26, 2002 4:55 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value 'xxxx
xx' overflowed an int column



Since CatalogueNumber is a vachar, try

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
('"&strArray&"') "




 

                    Joe Ingle

                    <Joe@k...       To:     "ASP Web HowTo"
<asp_web_howto@p...>                      
                    co.uk>               cc:

                                         Subject:     [asp_web_howto] RE:
The conversion of the varchar value      
                    03/26/2002            'xxxx     xx' overflowed an int
column                                   
                    11:55 AM

                    Please respond

                    to "ASP Web

                    HowTo"

 

 





Would that not be using CStr() in the wrong context?
I have tried:

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&CStr(strArray)&") "

But that doesn't work.

-----Original Message-----
From: TomMallard [mailto:mallard@s...]
Sent: Tuesday, March 26, 2002 4:49 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value
'xxxxxx' overflowed an int column


Have you tried using CStr()?

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CStr(CatalogueNumber) IN
("&strArray&") "

tom mallard
seattle
-----Original Message-----
From: Joe [mailto:joe@k...]
Sent: Tuesday, March 26, 2002 4:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] The conversion of the varchar value 'xxxxxx'
overflowed an int column


Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a simple
script to export x amount of records to either Word, Excel or Print
depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int
column. Maximum integer value exceeded.

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL ,
CatalogueNumberDescription [varchar] (500) NULL ,
DrawingNumber [int] NULL ,
Requester [varchar] (55) NULL ,
CatalogueNumberDate [smalldatetime] NULL

The problem is with the field CatalogueNumber. In an ideal word I would
use bigint as the datatype (see No above), but the table is part of a
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray        = request.form("cbxRecord")

mySQL = "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&strArray&") "

Can anyone shed some light on this? Have I missed something?

TIA

Joe

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20






---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20

Message #7 by "Drew, Ron" <RDrew@B...> on Tue, 26 Mar 2002 13:52:54 -0500

Do a replace
strArray =3D Replace(strArray, " , ", "','")
The IN has to read IN ('3214234','341234','12341324',413341'dsn2123')
...the beginning and end are OK just the variable has no quotes.

-----Original Message-----
From: Joe Ingle [mailto:Joe@k...]
Sent: Tuesday, March 26, 2002 12:15 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value 'xxxx
xx' overflowed an int column


Hi William

I've tried that too!! Really, I'm at a loss. If I do a response.write to
trap the string on it's way in, It looks fine. i.e

3214234 , 341234 , 12341324 , 413341 , dsn2123

It's just not making sense!

Joe

-----Original Message-----
From: william.sze@s... [mailto:william.sze@s...]
Sent: Tuesday, March 26, 2002 4:55 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value 'xxxx
xx' overflowed an int column



Since CatalogueNumber is a vachar, try

mySQL =3D "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
('"&strArray&"') "






                    Joe Ingle

                    <Joe@k...       To:     "ASP Web HowTo"
<asp_web_howto@p...>                     
                    co.uk>               cc:

                                         Subject:     [asp_web_howto]
RE:
The conversion of the varchar value     
                    03/26/2002            'xxxx     xx' overflowed an
int
column                                  
                    11:55 AM

                    Please respond

                    to "ASP Web

                    HowTo"









Would that not be using CStr() in the wrong context?
I have tried:

mySQL =3D "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&CStr(strArray)&") "

But that doesn't work.

-----Original Message-----
From: TomMallard [mailto:mallard@s...]
Sent: Tuesday, March 26, 2002 4:49 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: The conversion of the varchar value
'xxxxxx' overflowed an int column


Have you tried using CStr()?

mySQL =3D "SELECT * FROM tblCatalogueNumber WHERE CStr(CatalogueNumber) 
IN
("&strArray&") "

tom mallard
seattle
-----Original Message-----
From: Joe [mailto:joe@k...]
Sent: Tuesday, March 26, 2002 4:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] The conversion of the varchar value 'xxxxxx'
overflowed an int column


Hi Guys

Could you possibly help me keep a little of my hair! I'am writing a
simple script to export x amount of records to either Word, Excel or
Print depending on the users pref, and am getting to following error:

The conversion of the varchar value '149825001100' overflowed an int
column. Maximum integer value exceeded.

Table setup as follows:

RecordID [int] IDENTITY (1, 1) NOT NULL ,
CatalogueNumber [varchar] (50) NULL , CatalogueNumberDescription
[varchar] (500) NULL , DrawingNumber [int] NULL , Requester [varchar]
(55) NULL , CatalogueNumberDate [smalldatetime] NULL

The problem is with the field CatalogueNumber. In an ideal word I would
use bigint as the datatype (see No above), but the table is part of a
legacy system, and some of the Catalogue 'Numbers' are alpha numeric.

My code is as follows:

strArray        =3D request.form("cbxRecord")

mySQL =3D "SELECT * FROM tblCatalogueNumber WHERE CatalogueNumber IN
("&strArray&") "

Can anyone shed some light on this? Have I missed something?

TIA

Joe

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 






---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20

Return to Index

P2P Archives