Search results for query: *

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...

...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 message: Syntax error converting character string to smalldatetime...

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!

The only thing wit that is that rather than it add the day, month or year to the drop down list, I want it to select the value automatically from the options. Is this possible? Currently I have: <SELECT NAME="day"> <OPTION SELECTED Value=<%=day(Now())%>><%=day(Now())%> <OPTION>1...

Hi, I'm creating a room booking system and so far I have 3 drop down menus at the top of the screen where the user can select the day, month and year. I have hard coded the dates so that they can be written to the database when required, rather than add every date to the database and pull them...

Hi, I'm creating a room booking system and so far I have 3 drop down menus at the top of the screen where the user can select the day, month and year. I have hard coded the dates so that they can be written to the database when required, rather than add every date to the database and pull them...

PHV - I don't understand what you suggested to me that's why I didn't try it. Don't get where the C, V M etc come in in the join expression.

Done it! Lucky that Access practically write the SQL for you! SELECT dbo_Staff.ManagerNo, dbo_Staff.FName, dbo_Staff.LName, dbo_Validation.StaffNo, dbo_Course.CourseName, dbo_Validation.CourseDate, dbo_Staff_1.LName, dbo_Staff_1.FName FROM dbo_Staff AS dbo_Staff_1 INNER JOIN (dbo_Staff INNER...