Search results for query: *

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

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

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

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

Hi, I have 2 tables, staff and validation. Staff table has the fields STaffNo, LName, FName & ManagerNo. Validation has the fields StaffNo, CourseDate, etc.... I want to create query so that it displays the managerno, their LName and FName based on the staffno in the validation table, for all...

Could someone tell me how I link between tables in 2 different databases? I'm using SQL server 7 for both databases. Thanks,

I am trying to update the Password field usign the following code: If Me.cboLName <> "" And Me.cboFName <> "" Then strSQL = "SELECT dbo_Passwords.ManagerNo, Password, dbo_Staff.StaffNo FROM dbo_Passwords INNER JOIN dbo_Staff ON dbo_Passwords.ManagerNo = dbo_Staff.StaffNo WHERE dbo_Staff.LName =...

Hi, All i'm trying to do is run an SQL statement, store it in a record set then right different values depending on whether any records are found or not. The code I have at the moment is: If Me.txtManagerNo <> "" Then strSQL = "UPDATE dbo_Passwords SET password = 'password' WHERE...

Hello, I have a combo box with a list of surnames and I want the first name combo box to update depending on what is selected in the surname box. It works the first time but then the whole form has to be reset before it will work again. I'd appreciate any help.

Can anyone tell me how I can get a DTS to show my own error message rather than the default one? What is fails I want it to tell the 'non IT literate' user what the problem was. Also, my DTS is inserting records from one table to another. Can I get it to write the records which are not...

Hi, Can someone please tell me how to write the query for the following problem as I can't seem to get it right. I have 2 tables, one named CourseComplete and one named Validation. Both contain the fields CourseKey and Staffno. I want to select all the records from coursecomplete where the...

Hi, I have written some code which opens a new query and creates it depending on what a user has selected in a form. What I now want to do is show the query's results in a report.Does anybody know how I can do this? The problem I have is that the query will change every time depending on what...

Hi, Does anybody know how to automatically run a report based on the results of a query? I've created a dynamic query that changes depending on what the user selects in the form. The query runs fine, but what I really want is for the query to run "behind the scenes" and display the result in a...

Does anyone know what this error message means? I have 2 include files in my page and all I want to do is show one depending on the value in the querystring. This is my code:. <%If request.querystring("Delivery") = "ELearning" then ShowformELCourse false Else ShowformCourse false End if %>...

Hi, I'm using an animated gif as a submit button on a form. What I want is for the user to click the gif, have it run the animation and THEN submit the form. At the moment when I clcik it it just submits straight away. Is there any way I can get it to wait until the gif has completed once...

Can anyone help me with this statement: SELECT Staff.StaffNo, Validation.Completed, LName, FName, Staff.ManagerNo, CourseName, CourseDate, ManagerEvaluation.CourseKey as CourseKey2, ManagerEvaluation.ManagerNo as ManagerNo2, ManagerEvaluation.StaffNo as StaffNo2, ManagerEvaluation.Completed...

Hi, I have a column named FName and some of the data has a space at the end of the name. I need to delete the space (the last character) from each Fname. I have the query to select the fnamces that have a space at the end: SELECT FName from Staff where FName = '* ' But now I need to UPDATE...

Hi, I've linked the tables from my SQL Server 7.0 database to an Access database and it all works fine. The problem i'm having is that when another user tries to get into the database it opens up fine until they try to open a table. Then it tries to use their Windows login ID and password to...