SQL Server 7 Date format

Anon

Trying to insert a date in a form via odbc. The column is set smalldatetime.

I've tried both 2000-06-27 and 20000627 but get the error message:

"The conversion of char data type to smalldatetime data type
resulted in an out-of-range smalldatetime value"

Thanks for any advice.

Anon

I just inputted on my server with that format and it worked fine...how is the date being entered? Form post field, variable, etc?

Anon

Banging head on desk...

I had cut and paste the input box lines on the form as I had several to make. I forgot to change the name="" to match the variables.

Works fine now.

Anon

glad it worked out...
What are you doing with SQL/PHP? It's rare (it seems) to find another developer working in this misfit combo. It would be nice to have someone to bounce stuff off of, if you use it often. I find myself buried in this stuff daily working on intranet content for Bank of America, and often end up modifying mySQL code to work with SQL/Sybase.

Anon

Working on an entertainment news site. Because of a need to be on NT for a game we're working on I had to go with a shared NT box. Found a company that offered NT and PHP, but SQL Server 7 instead of mySQL.

What I'd really like to learn what to do is if SQL 7 has a function like mySQL's limit so I can have a query return the first ten results then the next ten, etc.

Any ideas?

Anon

I don't know of any SQL Server functions that will do that, but I am on a project now where I will have to deal with that soon. This is what I was thinking :

cycle through the results, assigning each record id# an array index#, and then have PHP return index # 0-9, 10-19, etc...

Either that or make a temp table to hold the results. Let me know if you find anything better/faster.

Anon

I'll have to try and figure that out. Still so new to SQL and PHP. If you get a working snippet, please let me know.

Have a great weekend.

Anon

I believe that the command for returning the top say 20 records would be "select top 20 * from members" this would return the top 20. There is also another way called ROWCOUNT but this doesn't work some SQL servers like MS JET.

I hope this helps

Best Regards

Richard Elliott