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 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 CallBacks.CallDate,CallBac

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

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 a

Time&Date 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. Any

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 Call

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 (211

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 & "' A

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 & "'

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 Tel

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 &"

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 tData.Occupation,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

[QueryAnalyzer]

Hi, I have just installed SQLServer7 after uninstalling SQL2k, and trying to laungh the Query Analyzer, but it doesn't seem wants to lauhch, is there any suggestion for me to do ?? Sam - Before posting, please check: http:/

INSERT within a loop

Hi, I wonder if there is a for loop statement in SQL, basically I want some data in all the records in the table in one loop through the records within SQL editor. Thanks, Sam - Before posting, please check: http://www.mys

MYSQL import wizard

Hi, I am having a problem with the imporot wizard in MySQL, as I don't know wha'ts wrong Im doine, I tried to import from a text file, csv, .mdb, all dont get me any data in the destination table, can some one advise ? (may be if some one is willing to talk me through MSN messagner/yahoo messan

Access2MySQL

Hi, I am trying to import 2 columns from Access to MySQL, I get the right number, but all fields are imported as null. Any suggestion ? Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

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