Recent content by dom24

Never mind, I got them the wrong way round! Works a treat! Thanks for your help.

That gets rid of the error message yeah thanks. But it still doesn't match it to my date in the records in the database. I've got a date set as smalldatetime 28/01/2005 and it's not finding it???

Yes it's really an excel file, that's the format it gets sent to me in. I've found something on the microsoft website which says that if you change the format of a column in excel, the data in the column must be re-entered for it to take affect. I've done this (a pain I know but I want to see...

I'm trying to take the day, month and year from a querystring and convert it into a data so that I can match it with a date in a record of the database. What I write the strSQL to the screen I get the following: SELECT * FROM Bookings WHERE StartDate = '28' + '1' + '2005' and then the error...

Hi, I'm trying to import data from an excel spreadsheet to a table in sql server 7. This all works fine, except that it the spreadsheet holds a column which stores dates. These dates do not appear when the data is imported into SQL, all the values are NULL. Anyone got any ideas why? I've tried...

Sorry I take that back (put it in the wrong place!) you're absolutely right! thanks so much. :0)

Still doesn't select the value being passed.

Even though the values being passed are already numeric?

Can anyone tell me where i'm going wrong with this code: <SELECT NAME="day"> <%For i = 1 to 31 d_options = d_options & "<option" If Request.QueryString("day") = i then If Request.QueryString("day") > "28" and Request.QueryString("month") = "2" and Request.QueryString("year") <> "2008" Then...

Never mind. Just me being thick :0) You're a great help, thanks again.

No I mean on the first page where I'm creating the option list there are no values in the list to be selected. The lists are just empty.

That's a great help Tarwn thanks. I'm not too hot on Javascript though so i'm gonna stick to your suggestion of building them dynamically. I've used what you said and create the drop downs aroudn it but i'm not getting any values in them? Any ideas why not?

Great. Thanks Tarwn!

Hi, I want to create a link to a page but pass the login details through the querystring ao that the user stays logged in. Is this possible? The user logs in, fills out a form, then I want a link so they can fill out another form which takes them back to teh start but keeps them logged in. At...

Great thanks i'll try it and let you know. Sorry about posting 2 by the way, didn't mean to!