dates sql and aspc....

[luna]

sql query in code looks like this :-

sql = "INSERT INTO livetracker
(ID,MortgageSourced,PostalPackIssued,PostalPackRet urned,SalesManager,Mortgag
eAdministrator,DateToMortgageAdmin,MortgageAppSubm itted,Lender,LendersRefere
nce,Solicitor,OfferIssued,CompCheckedBy,ToSales,Ca lledBy,MortgageResourced,C
allOutcome,OfferChecked) VALUES ('" + userid.Text.ToString + "' , " & msl +
" , " + pit + " , " + prt + " , '" + smo + "' , '" + ma + "' , " + dtma + "
, " + ms + " , '" + lend + "' , '" + lr + "' , '" + sol + "' , " + off + " ,
'" + comp + "' , " + tsl + " , '" + cc + "' , " + mr + " , '" + outc + "' ,
" + offchk + ");"

which outputs :

INSERT INTO livetracker
(ID,MortgageSourced,PostalPackIssued,PostalPackRet urned,SalesManager,Mortgag
eAdministrator,DateToMortgageAdmin,MortgageAppSubm itted,Lender,LendersRefere
nce,Solicitor,OfferIssued,CompCheckedBy,ToSales,Ca lledBy,MortgageResourced,C
allOutcome,OfferChecked) VALUES ('99' , 03/02/2004 , 03/02/2004 , 03/02/2004
, '' , '48' , 03/02/2004 , 03/02/2004 , '' , '' , '' , , '48' , 03/02/2004
, '48' , 03/02/2004 , '' , 03/02/2004);
but in the sql table all the dates are 01/01/1900 (im working in british
date format)

incidently im unsure as to where the 48s are coming from either!!

thanks

mark

[Scott Allen]

Just a couple suggestions:

1 - Parameterize the query. Building SQL strings in this fashion puts
you at a higher risk of injection attacks. It will also provide a
little more type safety. I don't think this will solve your problem
but it might prevent other problems down the road.
Some parameterized query examples are here:
http://msdn.microsoft.com/library/de...taadapters.asp

2 - Give us some more to work with. It's hard to see the exact problem
because I don't know if the variable msl is a date time or a string
or...

Hope this helps,

--
Scott
http://www.OdeToCode.com

On Tue, 3 Feb 2004 08:45:02 -0000, "luna" <lu**@themoon.com> wrote:

sql query in code looks like this :-

sql = "INSERT INTO livetracker
(ID,MortgageSourced,PostalPackIssued,PostalPackRe turned,SalesManager,Mortgag
eAdministrator,DateToMortgageAdmin,MortgageAppSub mitted,Lender,LendersRefere
nce,Solicitor,OfferIssued,CompCheckedBy,ToSales,C alledBy,MortgageResourced,C
allOutcome,OfferChecked) VALUES ('" + userid.Text.ToString + "' , " & msl +
" , " + pit + " , " + prt + " , '" + smo + "' , '" + ma + "' , " + dtma + "
, " + ms + " , '" + lend + "' , '" + lr + "' , '" + sol + "' , " + off + " ,
'" + comp + "' , " + tsl + " , '" + cc + "' , " + mr + " , '" + outc + "' ,
" + offchk + ");"

which outputs :

INSERT INTO livetracker
(ID,MortgageSourced,PostalPackIssued,PostalPackRe turned,SalesManager,Mortgag
eAdministrator,DateToMortgageAdmin,MortgageAppSub mitted,Lender,LendersRefere
nce,Solicitor,OfferIssued,CompCheckedBy,ToSales,C alledBy,MortgageResourced,C
allOutcome,OfferChecked) VALUES ('99' , 03/02/2004 , 03/02/2004 , 03/02/2004
, '' , '48' , 03/02/2004 , 03/02/2004 , '' , '' , '' , , '48' , 03/02/2004
, '48' , 03/02/2004 , '' , 03/02/2004);
but in the sql table all the dates are 01/01/1900 (im working in british
date format)

incidently im unsure as to where the 48s are coming from either!!

thanks

mark