**DONOTDELETE**
(Lurker)
2004-11-24 08:00 PM
Problem Varible Set

Hi, I have the follown code:

Code:
  
$dat="0"+$LengthBox.Text
if Exist ("C:\Journal.mdb")
$dsn='DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Bic\Tablas\Journal.mdb'
$sql="update parametros set cajero= "+$dat+", con=0, oficina="+$Sucursal+", psw_db='"+$PSWBD+"', dsn='"+$DSNBD+"', servidor='"+$SRVBUZ+"', usr_db='"+$USRBD+"'"
$recordset = DBCommand($dsn,$sql)




when execute the code, work fine if the vr for $LengthBox.Text = 500
but if the vr is 005, the code insert in to the bd the number 5 only, what can I do to solve this? tks 4r ur help.-


**DONOTDELETE**
(Lurker)
2004-11-24 08:02 PM
Re: Problem Varible Set

I use too the +Chr(34) to complete with "".. but not work

**DONOTDELETE**
(Lurker)
2004-11-24 08:07 PM
Re: Problem Varible Set

I´m sorry, for make waste its time, I found the problem.

I use +"'"+


**DONOTDELETE**
(Lurker)
2004-11-24 08:28 PM
Re: Problem Varible Set

cool.
k.