Have you put this SQL code inside a SQL String or are you just putting it in you ASP script? Remember that SQL syntax must be passed to your connection object as a string.
Dr B
I have a table with fields number,category,date and if i want to choose numbers of a particular category and date.
then the query will b
select number from <table name> where category=" " and date =" "
and it will display a list of numbers.
And wat if i want those numbers horizontally.Suppose i hav three numbers
123
234
678
and i want it to be like this
123,234,678
I have done my code till here,now wat next is:
i hav to store this data as a single record in a new table.
can u help me on this???plzzzzzz