sql query returns in wrong format

FAQ

Profile

sql query returns in wrong format

Database Help (Home) -> Visual Basic

Related Topics:

SQL Format - Hi Guys, I am trying to get a selection of fields from a DB. I can select specific records using sql = * FROM cds WHERE Artist = rs.open sql,cn Not problem. But I want to able to retireve records say starting with BR. SO when I try ..

INSERT SQL query help with VB please? - Hello, I am trying to run an SQL query on a database through VB6 which is supposed to add data to a table called tblNames. There are 4 text fields on the form where data is added. here's the code. Dim i As Integer Set db1 = New

update query - I have created an update query in my to change the date in the bound table to the sys date. However, the query will not accept '=Date' in the new value box. Does anyone know the correct function. The help gives it as 'Date' Ian

arrays - is there a way to the contents of an array (looping through the array) and storing each item in a comma delimited string? Thanks!

DataReport PageBreak - Hi everyone, I would like to know how to force pagebreak in a for example after 5 records printed. Thank you all

Next: Visual Basic: arrays

Author

Message

Paivijk

External

Since: Feb 23, 2005
Posts: 1

(Msg. 1) Posted: Wed Feb 23, 2005 2:15 am Post subject: sql query returns in wrong format Archived from groups: comp>lang>basic>visual>database (more info?)

Hi, Hope someone can help me with this. I have MS SQL 2000 database where i have Table "PriceList" and there a column "Pricemk" wich is data type "money". All data in this column is in form "10001,35". So why when i run .asp page with simple query to this table it returns prices in form "10001.35"? These asp pages worked just fine when they were in Windows NT server and now when i moved them to 2003 Server This problem occurred. -Paivi >> Stay informed about: sql query returns in wrong format

Display posts from previous:

	Database Help (Home) -> Visual Basic	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum