
October 11th, 2000, 04:34 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 23
|
|
|
Why use ASP+ADO open Sybase the "Numeric" DataField can't show properly?
<i><b>Originally posted by : Daniel (whbjiaozuo@263.net)</b></i><br />I use the Sybase as the Database,use<br />ADO to open the database,my code as follows:<br /><br />dim db <br /> set db = Server.CreateObject("ADODB.Connection")<br /> db.Open Application("ConnectString")<br /> SQL1 = "select * from tb_org_list where OrgCode='" & theorgcode & "'"<br /> set rs1 = db.Execute(SQL1)<br /> for i=0 to rs1.Fields.Count-1<br /> Response.Write rs1(i).Name & ":" & rs1(i) & "<br>"<br /> next<br /> rs1.Close<br /> Set rs1=Nothing<br />but the Numeric datafield can't display properly,<br />for example:'420' changed to '42';<br /> '1200' changed to '12';the '0' are got rid<br />of.
|