Re: LIMIT

2001-04-19 Thread Toby Miller
Believe me, it's not my first choice I hate working with M$ as much as the next guy. Unfortunately, not every project leans in the direction I want it to. As far as the LIMIT function goes I think MySQL has spoiled me. The only easy way to do pagination in ASP is through the ADO Object. The p

LIMIT

2001-04-19 Thread Toby Miller
Hey all, I've been using the LIMIT feature for paginating in MySQL for a long time now. It's really nice and makes paginating extremely simple. Up until now I've been using a dictionary object to get the same effect out of Microsoft SQL Server. Do any of you know a LIMIT equivalent for SQL Ser

Re: Insert Problem

2001-01-30 Thread Toby Miller
My bad, not enough sleep I guess. Thanks, Toby - Original Message - From: "Roger Ramirez" <[EMAIL PROTECTED]> To: "Toby Miller" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:33 AM Subject: Re:

Insert Problem

2001-01-30 Thread Toby Miller
I have a record being inserted and I don't see what the problem is. This is the insert statement: insert into auth_users (username, password, firstname, lastname, address1, address2, city, state, zip, phone, fax, email, hint) values ("username", "password", "firstname", "lastname", "Address1",