sintaxis

<i><b>Originally posted by : carlos de pedro (carlosdpa@uninet.es)</b></i><br />Hi,<br /><br />What´s wrong in this code:<br /><br />mySQL="select * from usuarios where Idusuarios =rstemp("iddistribuidor")" <br /><br />Thanks<br /><br />

<i><b>Originally posted by : charlesmartinez (cmartinez@apacmail.com)</b></i><br />try this:<br /><br />mySQL="select * from usuarios where Idusuarios =" & rstemp("iddistribuidor")<br /><br />also, makes sure column info you are trying to reference is the same format as your variable<br /><br />hope this works<br /><br /><br />------------<br />carlos de pedro at 10/17/2000 12:35:46 PM<br /><br />Hi,<br /><br />What´s wrong in this code:<br /><br />mySQL="select * from usuarios where Idusuarios =rstemp("iddistribuidor")" <br /><br />Thanks<br /><br />