ADO Function

G

Guest

Why doesn't the following function seem to work?

Function GetItemDesc(ItemNumber As String)

Set conn = Server.CreateObject("ADODB.Connection")
strConn = "DSN=AS020A"
conn.Open strConn
strQuery = "SELECT USIAJFL0.JFITDS FROM AS400.SCDBFP10.USIAJFL0 WHERE
USIAJFL0.JFITEM=ItemNumber"

conn.Execute(strQuery)


End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Function 5
ADO Error in Access calling from Excel 6
Problem in Excel 2007 when Range beyond 65536 in SELECT statement 2
Connecting to SQL Server via ADO 7
Help making code reusable 1
How Do I Do This VB Code In C# - Set Conn = Server.CreateObject("ADODB.Connection") 2
getting an error when running my asp script 8
Using ADO 2

Top