Page 1 of 1 1
Topic Options
#130131 - 2004-11-24 08:00 PM Problem Varible Set
Anonymous
Unregistered


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.-

Top
#130132 - 2004-11-24 08:02 PM Re: Problem Varible Set
Anonymous
Unregistered


I use too the +Chr(34) to complete with "".. but not work
Top
#130133 - 2004-11-24 08:07 PM Re: Problem Varible Set
Anonymous
Unregistered


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

I use +"'"+

Top
#130134 - 2004-11-24 08:28 PM Re: Problem Varible Set
Anonymous
Unregistered


cool.
k.

Top
Page 1 of 1 1


Moderator:  Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 507 anonymous users online.
Newest Members
gespanntleuchten, DaveatAdvanced, Paulo_Alves, UsTaaa, xxJJxx
17864 Registered Users

Generated in 0.048 seconds in which 0.022 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org