How2unsubscribe?

Hi list, I have migrated to SQLServer, so I wonder if some one can direct me how to unsubscribe please. Thanks. Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

OLEDBSQL connection

Hi, I wonder if someone can paste a OLEDBSQL provider connection string to look at . Many thanks.. Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Query from5tables

Hi I want to get data from 5 tables to a form..the tables are linked in the following way. AppointmentTable 1 to 1 client ClientTable one to many ClientStaffTable SaleStaffTable one to many ClientTable AttendantsTable many to one AppointmentTable AttendantsTable one to one ClientStaffTable And

Date field

Hi. I am trying to store a date in the following format '08/12/2002' pr '08/12/2002' or any other format if I have to ...on SQLServer 7. Basically I want to use TodaysDate = Date' Date is the system date function strSQL = SELECT * FROM CallBacks WHERE CallDate = TodaysDate Is there any

INSERT

Hi, I have a ntext data type on SQLServer7, and I have the following statement: sCVInsertSQL = INSERT INTO CVs CV VALUE ' strCV ' Whats wrong with that please ? Ps. strCV is a complete CV contains many lines. - Before

Date conversion

Hi all, I have a datetime data field in SQLServer7, and I am trying to get a recordset according to criteria that the CallDate field in the database equals todays date 09/12/2002 Dim TodaysDate TodaysDate= cDate(Date) sCallsSQL = SELECT

Syntax error in INSERT

Hi, I have the following statement causing an error near , sNewCallBackSQL = INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES ( ExLearnerID , sCallDate , sCallTime ) The executed statement is: INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113 , , )I

Trying2insert Date2table

Hi, I am trying to insert the following value to a Date/Time field in SQLServer7 table. Here is the Line values Im tring to execute sNewCallBackSQLINSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113 , 01/01/2002 , 0:00) Here is the statement: sNewCallBackSQL = INSERT INTO

TimeDate in SQLServer7

Hi I am inserting a Time like 06:00 from my code to a Date/Time field in SQLServer7...the value I am sending in my program is perfectly finebut...when It gets in the database... it gets screwed up to be like 01/01/1900 06:00:00 What I need really is only the time rather than Date/Time.

Error in SELECT

Hi, I have the following statement that is causing a syntax error: sLearnerSQL = SELECT * From LearnerDetails WHERE Title=' sTitle ' AND FName=' sFName ' AND LName=' sLName ' AND Add1=' sAdd1 ' AND Add2=' sAdd2 ' AND Town=' sTown ' AND County=' sCounty ' AND PostCode=' sPostCode

Error in SELECT

Please note...the values that don't have ' ' are int type. Here is the error bellow: SELECT * From LearnerDetails WHERE Title='Mr' AND FName='Natasha' AND LName='Burkenshaw' AND Add1='17 Cromer Road' AND Town='Hornchurch' AND County='Essex' AND PostCode='RM11 1EY' AND CurrentlyEmployed= AND

Error in SQLStatement

Hi all,, I have the following SQL statements...one of them has an error saying :Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near ' AND Town='. Statement 1** sCheckSQL = SELECT * From LearnerDetails WHERE Title=' sTitle ' AND

Missing quotation mark

Hi all, Sorry about the rain of emails I am having at this list today :-) I have a missing quotation marks in the following which I can't see. sCheckSQL = SELECT * From LearnerDetails WHERE Title=' sTitle ' AND FName=' sFName ' AND LName=' sLName ' AND Add1=' sAdd1 ' AND Town=' sTown

Isert arecord to database error

Hi I am trying to insert a record to SQLServer database and gettign the following error: Microsoft OLE DB Provider for SQL Server error '80040e14' The name 'Mr' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted Any idea ?

SQL Query

Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke

statement doesnt work onMySQL

Hi, I have the following SQL statement that works fine on Access but it doesn't work on MySQL... select MarketData.* FROM MarketData where MarketData.CustID IN (SELECT ContactID from Contacts where CustID =1) Any advise please?? Regards, Sam

Access2MySQL

Hi all, After setting the field data type in MySQL to Text, which is the same data type for Access data type where the data is being imported from, the import process was succeful and the same number of rows was imported, BUT I don't see any data in the MySQL, all I see is Null, Null.