|
 |
asp_databases thread: Re: Update (question)
Message #1 by "Savonnya D. Rodrigues" <srod@f...> on Wed, 24 Jan 2001 17:13:26 -0600
|
|
I have two update statements to update my tables in two locations.
Everything is working fine, but when I try to update on record it updates
the whole table. I used the where clause and it did not change anything. Do
you have any suggestions?
strSQL1 = "Update Computer Set " & "SerialNum = '" &
Request.Form("txtSerialNum") & "'," & "PNNum = '" & Request.Form("txtPNNum")
& "'," & "ComputerName = '" & Request.Form("txtComputerName") & "'," &
"UserName ='" & Request.Form("txtUserName") & "'," & "IPAddr = '" &
Request.Form("txtIPAddr") & "'," & "NodePrinterID = '" &
Request.Form("txtNodePrinterID") & "'," & "Manufacture = '" &
Request.Form("txtManufacture") & "'," & "ProductName ='" &
Request.Form("txtProductName") & "'," & "Version = '" &
Request.Form("txtVersion") & "'," & "Description ='" &
Request.Form("txtDescription") & "'," & "Status = '" &
Request.Form("txtStatus") & "'," & "UserID = '" & Request.Form("txtUserID")
& "'," & "Comment =' " & Request.Form("txtComment") & "' where Serial Num
'" & Request.Form("txtSerialNum") &"'"
strSQL2 = "Update PurchaseOrder Set " & "SerialNum = '" &
Request.Form("txtSerialNum") & "'," & "POComment = '" &
Request.Form("txtPOComment") & "'," & "PCQuote = '" &
Request.Form("txtPCQoute") & "'," & "DateReceived = '" &
Request.Form("txtDateReceived") & "'," & "DateApproved = '" &
Request.Form("txtDateApproved") & "'," & "Cost = '" &
Request.Form("txtCost") & "'," & "MaintenanceAgree = '" &
Request.Form("txtMaintenanceAgree") & "',"& "LicenseLocation = '" &
Request.Form("txtLicenseLocation") & "'where Serial Num = '" &
Request.Form("txtSerialNum") &"'"
----- Original Message -----
From: "Imar Spaanjaars" <Imar@S...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, January 17, 2001 10:16 AM
Subject: [asp_databases] Re: Insert into (question)
> As a general tips for post like this: not only post the strSQL = " bla bla
> bla", but also post the outcome of it to this list.
> Do a Response.Write(strSQL) just before you execute it.
>
> Now as for your problem: I think it's the DateReceived and DateApproved
> fields that's causing the error.
> Dates in Microsoft Access need to be delimited by a # (it's a ' in SQL
> server, so if you are planning to upgrade, it's better to define a CONST
> DATE_DELIMITER that holds the character, so you can easily switch between
> the two).
>
> Also, when you list the fields, there is no need to break up the string
> (Insert into PurchaseOrder (POComment,PCQuote , " & "DateReceived,)
>
> So try this instead:
>
> strSQL = "Insert into PurchaseOrder (POComment,PCQuote, " & _
> "DateReceived, DateApproved, Cost, MaintenanceAgree) " & _
> "Values('" & _
> Request.Form("txtPOComment") & "', '" & _
> Request.Form("txtPCQuote") & "', #" & _
> Request.Form("txtDateReceived") & "#, #" & _
> Request.Form("txtDateApproved") & "#, '" & _
> Request.Form("txtCost") & "', '" & _
> Request.Form("txtMaintenanceAgree") & "')"
>
> If Cost is a number in the database, leave out the ' on both sites....
>
>
> HtH
>
> Imar
>
>
>
> At 09:45 AM 1/17/2001 -0600, you wrote:
> >I did the delimited my fields, thanks. Now, I am testing each insert into
> >statement. I got 1 out of 3. I am having problems with one. The error is:
> >
> >Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
> > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
> >criteria expression.
> > /webpub/ESS/ess/softwareA.asp, line 169
> >
> >I check my actual database and deleted the query statements I had in
there.
> >Then I ran it again and got the same error. Can you please help? The
insert
> >into statement that I am having errors with is:
> >
> >strSQL = "Insert into PurchaseOrder (POComment,PCQuote , " &
"DateReceived,
> >DateApproved," & "Cost, MaintenanceAgree) " & "Values('" &
> >Request.Form("txtPOComment") & "','" & Request.Form("txtPCQuote") & "','"
&
> >Request.Form("txtDateReceived") & "','" & Request.Form("txtDateApproved")
&
> >"','" & Request.Form("txtCost") & "','" &
> >Request.Form("txtMaintenanceAgree") & "')"
> >
> >Also, I checked my values in my statement verses my table in my database
> >and it is fine.
> >
> >
> >
> >Thanks!!!
>
>
Message #2 by Imar Spaanjaars <Imar@S...> on Thu, 25 Jan 2001 08:34:38 +0100
|
|
Usually what helps when you have problems like this, is to write the SQL
statement to the browser. Then copy and paste the query in Access or in SQL
server to see if it works there.
Usually, you see right away what the problem is (or the database will tell
you).
So do a Response.Write(strSQL1) before you execute the query. If it still
doesn't work, post the results of the Response.Write to this list.
Imar
At 05:13 PM 1/24/2001 -0600, you wrote:
>I have two update statements to update my tables in two locations.
>Everything is working fine, but when I try to update on record it updates
>the whole table. I used the where clause and it did not change anything. Do
>you have any suggestions?
>
>
>strSQL1 = "Update Computer Set " & "SerialNum = '" &
>Request.Form("txtSerialNum") & "'," & "PNNum = '" & Request.Form("txtPNNum")
>& "'," & "ComputerName = '" & Request.Form("txtComputerName") & "'," &
>"UserName ='" & Request.Form("txtUserName") & "'," & "IPAddr = '" &
>Request.Form("txtIPAddr") & "'," & "NodePrinterID = '" &
>Request.Form("txtNodePrinterID") & "'," & "Manufacture = '" &
>Request.Form("txtManufacture") & "'," & "ProductName ='" &
>Request.Form("txtProductName") & "'," & "Version = '" &
>Request.Form("txtVersion") & "'," & "Description ='" &
>Request.Form("txtDescription") & "'," & "Status = '" &
>Request.Form("txtStatus") & "'," & "UserID = '" & Request.Form("txtUserID")
>& "'," & "Comment =' " & Request.Form("txtComment") & "' where Serial Num
>'" & Request.Form("txtSerialNum") &"'"
>
>strSQL2 = "Update PurchaseOrder Set " & "SerialNum = '" &
>Request.Form("txtSerialNum") & "'," & "POComment = '" &
>Request.Form("txtPOComment") & "'," & "PCQuote = '" &
>Request.Form("txtPCQoute") & "'," & "DateReceived = '" &
>Request.Form("txtDateReceived") & "'," & "DateApproved = '" &
>Request.Form("txtDateApproved") & "'," & "Cost = '" &
>Request.Form("txtCost") & "'," & "MaintenanceAgree = '" &
>Request.Form("txtMaintenanceAgree") & "',"& "LicenseLocation = '" &
>Request.Form("txtLicenseLocation") & "'where Serial Num = '" &
>Request.Form("txtSerialNum") &"'"
Message #3 by Gregory_Griffiths@c... on Thu, 25 Jan 2001 08:32:14 +0000
|
|
try printing your SQL strings just after you have created them to see
what they actually contain, you may find that there is a problem there.
> -----Original Message-----
> From: srod@f... [mailto:srod@f...]
> Sent: 24 January 2001 23:13
> To: asp_databases@p...
> Cc: srod@f...
> Subject: [asp_databases] Re: Update (question)
>
>
> I have two update statements to update my tables in two locations.
> Everything is working fine, but when I try to update on
> record it updates
> the whole table. I used the where clause and it did not
> change anything. Do
> you have any suggestions?
>
>
> strSQL1 = "Update Computer Set " & "SerialNum = '" &
> Request.Form("txtSerialNum") & "'," & "PNNum = '" &
> Request.Form("txtPNNum")
> & "'," & "ComputerName = '" & Request.Form("txtComputerName") & "'," &
> "UserName ='" & Request.Form("txtUserName") & "'," & "IPAddr = '" &
> Request.Form("txtIPAddr") & "'," & "NodePrinterID = '" &
> Request.Form("txtNodePrinterID") & "'," & "Manufacture = '" &
> Request.Form("txtManufacture") & "'," & "ProductName ='" &
> Request.Form("txtProductName") & "'," & "Version = '" &
> Request.Form("txtVersion") & "'," & "Description ='" &
> Request.Form("txtDescription") & "'," & "Status = '" &
> Request.Form("txtStatus") & "'," & "UserID = '" &
> Request.Form("txtUserID")
> & "'," & "Comment =' " & Request.Form("txtComment") & "'
> where Serial Num
> '" & Request.Form("txtSerialNum") &"'"
>
> strSQL2 = "Update PurchaseOrder Set " & "SerialNum = '" &
> Request.Form("txtSerialNum") & "'," & "POComment = '" &
> Request.Form("txtPOComment") & "'," & "PCQuote = '" &
> Request.Form("txtPCQoute") & "'," & "DateReceived = '" &
> Request.Form("txtDateReceived") & "'," & "DateApproved = '" &
> Request.Form("txtDateApproved") & "'," & "Cost = '" &
> Request.Form("txtCost") & "'," & "MaintenanceAgree = '" &
> Request.Form("txtMaintenanceAgree") & "',"& "LicenseLocation = '" &
> Request.Form("txtLicenseLocation") & "'where Serial Num = '" &
> Request.Form("txtSerialNum") &"'"
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "Imar Spaanjaars" <Imar@S...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, January 17, 2001 10:16 AM
> Subject: [asp_databases] Re: Insert into (question)
>
>
> > As a general tips for post like this: not only post the
> strSQL = " bla bla
> > bla", but also post the outcome of it to this list.
> > Do a Response.Write(strSQL) just before you execute it.
> >
> > Now as for your problem: I think it's the DateReceived and
> DateApproved
> > fields that's causing the error.
> > Dates in Microsoft Access need to be delimited by a # (it's
> a ' in SQL
> > server, so if you are planning to upgrade, it's better to
> define a CONST
> > DATE_DELIMITER that holds the character, so you can easily
> switch between
> > the two).
> >
> > Also, when you list the fields, there is no need to break
> up the string
> > (Insert into PurchaseOrder (POComment,PCQuote , " & "DateReceived,)
> >
> > So try this instead:
> >
> > strSQL = "Insert into PurchaseOrder (POComment,PCQuote, " & _
> > "DateReceived, DateApproved, Cost, MaintenanceAgree) " & _
> > "Values('" & _
> > Request.Form("txtPOComment") & "', '" & _
> > Request.Form("txtPCQuote") & "', #" & _
> > Request.Form("txtDateReceived") & "#, #" & _
> > Request.Form("txtDateApproved") & "#, '" & _
> > Request.Form("txtCost") & "', '" & _
> > Request.Form("txtMaintenanceAgree") & "')"
> >
> > If Cost is a number in the database, leave out the ' on
> both sites....
> >
> >
> > HtH
> >
> > Imar
> >
> >
> >
> > At 09:45 AM 1/17/2001 -0600, you wrote:
> > >I did the delimited my fields, thanks. Now, I am testing
> each insert into
> > >statement. I got 1 out of 3. I am having problems with
> one. The error is:
> > >
> > >Error Type:
> > > Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
> > > [Microsoft][ODBC Microsoft Access Driver] Data
> type mismatch in
> > >criteria expression.
> > > /webpub/ESS/ess/softwareA.asp, line 169
> > >
> > >I check my actual database and deleted the query
> statements I had in
> there.
> > >Then I ran it again and got the same error. Can you please
> help? The
> insert
> > >into statement that I am having errors with is:
> > >
> > >strSQL = "Insert into PurchaseOrder (POComment,PCQuote , " &
> "DateReceived,
> > >DateApproved," & "Cost, MaintenanceAgree) " & "Values('" &
> > >Request.Form("txtPOComment") & "','" &
> Request.Form("txtPCQuote") & "','"
> &
> > >Request.Form("txtDateReceived") & "','" &
> Request.Form("txtDateApproved")
> &
> > >"','" & Request.Form("txtCost") & "','" &
> > >Request.Form("txtMaintenanceAgree") & "')"
> > >
> > >Also, I checked my values in my statement verses my table
> in my database
> > >and it is fine.
> > >
> > >
> > >
> > >Thanks!!!
> >
>
Message #4 by "Savonnya D. Rodrigues" <srod@f...> on Thu, 25 Jan 2001 09:47:25 -0600
|
|
I did the response.write with the update statement and it updated, but when
it entered into the access database it updated everthing. Is there something
I am missing in my update statement? Below, is the respose.write that I
executed using the response.write.
The following update string was executed and the values updated in the
Hardware table.
Update Computer Set SerialNum = '34444',PNNum = '8',ComputerName
'8',UserName ='',IPAddr
'',NodePrinterID = '',Manufacture = 'HP',ProductName ='vectra',Version
'series',Description
='desktop',Status = 'In Use',UserID = '',Comment =' 'The following update
string was executed and the
values updated in the Hardware table.
Update PurchaseOrder Set SerialNum = '34444',POComment = '8',PCQuote
'',DateReceived
'12:00:39',DateApproved = '12:00:39',Cost = '32',MaintenanceAgree
'8',LicenseLocation = '8'
----- Original Message -----
From: "Imar Spaanjaars" <Imar@S...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, January 25, 2001 1:34 AM
Subject: [asp_databases] Re: Update (question)
> Usually what helps when you have problems like this, is to write the SQL
> statement to the browser. Then copy and paste the query in Access or in
SQL
> server to see if it works there.
> Usually, you see right away what the problem is (or the database will tell
> you).
>
> So do a Response.Write(strSQL1) before you execute the query. If it still
> doesn't work, post the results of the Response.Write to this list.
>
> Imar
>
>
> At 05:13 PM 1/24/2001 -0600, you wrote:
> >I have two update statements to update my tables in two locations.
> >Everything is working fine, but when I try to update on record it updates
> >the whole table. I used the where clause and it did not change anything.
Do
> >you have any suggestions?
> >
> >
> >strSQL1 = "Update Computer Set " & "SerialNum = '" &
> >Request.Form("txtSerialNum") & "'," & "PNNum = '" &
Request.Form("txtPNNum")
> >& "'," & "ComputerName = '" & Request.Form("txtComputerName") & "'," &
> >"UserName ='" & Request.Form("txtUserName") & "'," & "IPAddr = '" &
> >Request.Form("txtIPAddr") & "'," & "NodePrinterID = '" &
> >Request.Form("txtNodePrinterID") & "'," & "Manufacture = '" &
> >Request.Form("txtManufacture") & "'," & "ProductName ='" &
> >Request.Form("txtProductName") & "'," & "Version = '" &
> >Request.Form("txtVersion") & "'," & "Description ='" &
> >Request.Form("txtDescription") & "'," & "Status = '" &
> >Request.Form("txtStatus") & "'," & "UserID = '" &
Request.Form("txtUserID")
> >& "'," & "Comment =' " & Request.Form("txtComment") & "' where Serial Num
> >'" & Request.Form("txtSerialNum") &"'"
> >
> >strSQL2 = "Update PurchaseOrder Set " & "SerialNum = '" &
> >Request.Form("txtSerialNum") & "'," & "POComment = '" &
> >Request.Form("txtPOComment") & "'," & "PCQuote = '" &
> >Request.Form("txtPCQoute") & "'," & "DateReceived = '" &
> >Request.Form("txtDateReceived") & "'," & "DateApproved = '" &
> >Request.Form("txtDateApproved") & "'," & "Cost = '" &
> >Request.Form("txtCost") & "'," & "MaintenanceAgree = '" &
> >Request.Form("txtMaintenanceAgree") & "',"& "LicenseLocation = '" &
> >Request.Form("txtLicenseLocation") & "'where Serial Num = '" &
> >Request.Form("txtSerialNum") &"'"
>
Message #5 by "Peter Lanoie" <planoie@e...> on Thu, 25 Jan 2001 12:27:44 -0500
|
|
You don't have any WHERE clause in the SQL... the update will update all the
records without that restriction.
Your original post contained "where Serial Num='" &
Request.Form("txtSerialNum") &"'"
If that's not making it onto the update query, which it doesn't look like it
is...then the update applies to ALL records.
The field name you have in there is "Serial Num", that might be the problem.
A space in the field name could be a problem. If you need to, put that
field name in ' or maybe use the [ ] characters:
"where 'Serial Num'='" & Request.Form("txtSerialNum") &"'"
or
"where [Serial Num]='" & Request.Form("txtSerialNum") &"'"
Give that a shot and see what you get.
Good Luck,
-Peter L
-----Original Message-----
From: Savonnya D. Rodrigues [mailto:srod@f...]
Sent: Thursday, January 25, 2001 10:47 AM
To: ASP Databases
Subject: [asp_databases] Re: Update (question)
I did the response.write with the update statement and it updated, but when
it entered into the access database it updated everthing. Is there something
I am missing in my update statement? Below, is the respose.write that I
executed using the response.write.
The following update string was executed and the values updated in the
Hardware table.
Update Computer Set SerialNum = '34444',PNNum = '8',ComputerName
'8',UserName ='',IPAddr
'',NodePrinterID = '',Manufacture = 'HP',ProductName ='vectra',Version
'series',Description
='desktop',Status = 'In Use',UserID = '',Comment =' 'The following update
string was executed and the
values updated in the Hardware table.
Update PurchaseOrder Set SerialNum = '34444',POComment = '8',PCQuote
'',DateReceived
'12:00:39',DateApproved = '12:00:39',Cost = '32',MaintenanceAgree
'8',LicenseLocation = '8'
----- Original Message -----
From: "Imar Spaanjaars" <Imar@S...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, January 25, 2001 1:34 AM
Subject: [asp_databases] Re: Update (question)
> Usually what helps when you have problems like this, is to write the SQL
> statement to the browser. Then copy and paste the query in Access or in
SQL
> server to see if it works there.
> Usually, you see right away what the problem is (or the database will tell
> you).
>
> So do a Response.Write(strSQL1) before you execute the query. If it still
> doesn't work, post the results of the Response.Write to this list.
>
> Imar
>
>
> At 05:13 PM 1/24/2001 -0600, you wrote:
> >I have two update statements to update my tables in two locations.
> >Everything is working fine, but when I try to update on record it updates
> >the whole table. I used the where clause and it did not change anything.
Do
> >you have any suggestions?
> >
> >
> >strSQL1 = "Update Computer Set " & "SerialNum = '" &
> >Request.Form("txtSerialNum") & "'," & "PNNum = '" &
Request.Form("txtPNNum")
> >& "'," & "ComputerName = '" & Request.Form("txtComputerName") & "'," &
> >"UserName ='" & Request.Form("txtUserName") & "'," & "IPAddr = '" &
> >Request.Form("txtIPAddr") & "'," & "NodePrinterID = '" &
> >Request.Form("txtNodePrinterID") & "'," & "Manufacture = '" &
> >Request.Form("txtManufacture") & "'," & "ProductName ='" &
> >Request.Form("txtProductName") & "'," & "Version = '" &
> >Request.Form("txtVersion") & "'," & "Description ='" &
> >Request.Form("txtDescription") & "'," & "Status = '" &
> >Request.Form("txtStatus") & "'," & "UserID = '" &
Request.Form("txtUserID")
> >& "'," & "Comment =' " & Request.Form("txtComment") & "' where Serial Num
> >'" & Request.Form("txtSerialNum") &"'"
> >
> >strSQL2 = "Update PurchaseOrder Set " & "SerialNum = '" &
> >Request.Form("txtSerialNum") & "'," & "POComment = '" &
> >Request.Form("txtPOComment") & "'," & "PCQuote = '" &
> >Request.Form("txtPCQoute") & "'," & "DateReceived = '" &
> >Request.Form("txtDateReceived") & "'," & "DateApproved = '" &
> >Request.Form("txtDateApproved") & "'," & "Cost = '" &
> >Request.Form("txtCost") & "'," & "MaintenanceAgree = '" &
> >Request.Form("txtMaintenanceAgree") & "',"& "LicenseLocation = '" &
> >Request.Form("txtLicenseLocation") & "'where Serial Num = '" &
> >Request.Form("txtSerialNum") &"'"
>
Message #6 by "Wally Burfine" <oopconsultant@h...> on Thu, 25 Jan 2001 21:58:36 -0000
|
|
there is no predicate on the update. You must supply a where clause to limit
the set of records that will be updated
>From: "Savonnya D. Rodrigues" <srod@f...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Re: Update (question)
>Date: Thu, 25 Jan 2001 09:47:25 -0600
>
>I did the response.write with the update statement and it updated, but when
>it entered into the access database it updated everthing. Is there
>something
>I am missing in my update statement? Below, is the respose.write that I
>executed using the response.write.
>
>The following update string was executed and the values updated in the
>Hardware table.
>
>Update Computer Set SerialNum = '34444',PNNum = '8',ComputerName
>'8',UserName ='',IPAddr
>'',NodePrinterID = '',Manufacture = 'HP',ProductName ='vectra',Version
>'series',Description
>='desktop',Status = 'In Use',UserID = '',Comment =' 'The following update
>string was executed and the
>values updated in the Hardware table.
>
>Update PurchaseOrder Set SerialNum = '34444',POComment = '8',PCQuote
>'',DateReceived
>'12:00:39',DateApproved = '12:00:39',Cost = '32',MaintenanceAgree
>'8',LicenseLocation = '8'
>----- Original Message -----
>From: "Imar Spaanjaars" <Imar@S...>
>To: "ASP Databases" <asp_databases@p...>
>Sent: Thursday, January 25, 2001 1:34 AM
>Subject: [asp_databases] Re: Update (question)
>
>
> > Usually what helps when you have problems like this, is to write the SQL
> > statement to the browser. Then copy and paste the query in Access or in
>SQL
> > server to see if it works there.
> > Usually, you see right away what the problem is (or the database will
>tell
> > you).
> >
> > So do a Response.Write(strSQL1) before you execute the query. If it
>still
> > doesn't work, post the results of the Response.Write to this list.
> >
> > Imar
> >
> >
> > At 05:13 PM 1/24/2001 -0600, you wrote:
> > >I have two update statements to update my tables in two locations.
> > >Everything is working fine, but when I try to update on record it
>updates
> > >the whole table. I used the where clause and it did not change
>anything.
>Do
> > >you have any suggestions?
> > >
> > >
> > >strSQL1 = "Update Computer Set " & "SerialNum = '" &
> > >Request.Form("txtSerialNum") & "'," & "PNNum = '" &
>Request.Form("txtPNNum")
> > >& "'," & "ComputerName = '" & Request.Form("txtComputerName") & "'," &
> > >"UserName ='" & Request.Form("txtUserName") & "'," & "IPAddr = '" &
> > >Request.Form("txtIPAddr") & "'," & "NodePrinterID = '" &
> > >Request.Form("txtNodePrinterID") & "'," & "Manufacture = '" &
> > >Request.Form("txtManufacture") & "'," & "ProductName ='" &
> > >Request.Form("txtProductName") & "'," & "Version = '" &
> > >Request.Form("txtVersion") & "'," & "Description ='" &
> > >Request.Form("txtDescription") & "'," & "Status = '" &
> > >Request.Form("txtStatus") & "'," & "UserID = '" &
>Request.Form("txtUserID")
> > >& "'," & "Comment =' " & Request.Form("txtComment") & "' where Serial
>Num
>
> > >'" & Request.Form("txtSerialNum") &"'"
> > >
> > >strSQL2 = "Update PurchaseOrder Set " & "SerialNum = '" &
> > >Request.Form("txtSerialNum") & "'," & "POComment = '" &
> > >Request.Form("txtPOComment") & "'," & "PCQuote = '" &
> > >Request.Form("txtPCQoute") & "'," & "DateReceived = '" &
> > >Request.Form("txtDateReceived") & "'," & "DateApproved = '" &
> > >Request.Form("txtDateApproved") & "'," & "Cost = '" &
> > >Request.Form("txtCost") & "'," & "MaintenanceAgree = '" &
> > >Request.Form("txtMaintenanceAgree") & "',"& "LicenseLocation = '" &
> > >Request.Form("txtLicenseLocation") & "'where Serial Num = '" &
> > >Request.Form("txtSerialNum") &"'"
> >
>
|
|
|
View Cart
