Replication between MySql and MS Sql Server

have done some searching on Google and in the FAQ, and have not come up with anything that I have found useful. Any comments greatly appreciated, Thanks, John Lodge > John Lodge > Software Engineer > Redwood Technologies Limited > T +[44] (0)1344 304 344 > F +[44] (0)1344 304 345 &

RE: Order by list?

George, What I would do is include an auto_increment column in the table and order the select queries by that column. I don't know of a way of doing what you want with existing data. John Lodge -Original Message- From: George Marnellos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Mar

RE: Complex query with PHP/MySQL

($tmpquery) - 4); // remove extra AND I haven't tried this with checkboxes, but you should get the idea. This works with other queries that I have done. John Lodge -Original Message- From: Trelfa, Jonathon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:45 PM To: SQL Mailing

RE: Mysql Date Functions - input

I use a JavaScript date picker for all date fields that need to be entered. This can display in on format and present the required -mm-dd format to MySQL. I can send the relevant JavaScript and examples if required. I found it on the web. It is not my own work. John Lodge -Original

RE: help | i'm new

It looks as if you need the php function nl2br(). John L -Original Message- From: Julio [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 4:33 PM To: [EMAIL PROTECTED] Subject: help | i'm new hi. i'm a dumb newbie. excuse my ignorance. i'm using a field to store content f

RE: Newbie alert!

Rick, The error suggests that libmysqlclient is not in /usr/local/lib/mysql. the -L must refer to the directory containing libmysqlclient.a for the compile to succeed. John Lodge -Original Message- From: Rick Runowski [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 11:18 PM

RE: insert picture file in MySQL (+php)

Reuben, Try http://www.phpbuilder.com/columns/florian19991014.php3 John Lodge -Original Message- From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 3:08 PM To: [EMAIL PROTECTED] Subject: insert picture file in MySQL (+php) Hi, I remember reading

RE: Avanced query question

Parse the hours column in the result set. Keep track of last hour number processed. If a number is missing, then its count can be assumed to be zero. John Lodge -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 09, 2002 10:55 AM To: Mysql Subject

RE: Hello! Date question....

See the manual reference to the 'timestamp' type. -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 5:50 PM To: [EMAIL PROTECTED] Subject: Hello! Date question Hi all... This is my first post to the list. I've been working on MySQL no

RE: Images in MySql

Eric, Generally you would store references to the images in the database as a full or partial pathname. You can store binary data in the db itself using the BLOB type but this is not necessarily the most efficient approach to take John Lodge -Original Message- From: Eric Torr Klopper

RE: Running SQL Scripts

The file extension can be anything you like the command is mysql < file_name -Original Message- From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:19 PM To: MySQL (E-mail) Subject: Running SQL Scripts Dudes & Dudettes, I got a SQL script with all the

RE: Two daemons, 1 data dir.

ld like to suggest Linux, but I would think that the file locking is better in SOlaris. Hope this is helpful. John Lodge -Original Message- From: CyberSushi [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 11:39 AM To: mysql Subject: Two daemons, 1 data dir. Hi, I've got

RE: alter table example.

Hello, Your query could use text or varchar(30) or char(30) but not text(30). John L -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 3:08 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: alter table example. Because TEXT does

RE: TEMPORARY TABLES

If you are using php, the function you want is mysql_data_seek($result,0) to reset the result set. John Lodge -Original Message- From: Walter D. Funk [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: TEMPORARY TABLES Ive just another

RE: MySQL Book

MySql & mSQL O'Reilly press isbn 1-56592-434-7 -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: MySQL Book Which is the **best, easy, compact** book available on MySQL. Delhi India. --

RE: C-API Query

sel = mysql_query(connection, "select e-no,ename from employee"); printf("sel %d\n",sel); } John Lodge -Original Message- From: udayashankarl_n [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 11:51 AM To: [EMAIL PROTECTED] Subject: C-API Query

RE: auto_increment

Manish, If you manually insert a record with a value of 100 in the auto_increment field, then it will work from then on. If there is a way to create the table telling the value to start at 100, then I don't know what it is. Hope this is a help John Lodge -Original Message-

MyODBC problems with file DSN

ther NT box and is accessed using UNC e.g. > //machine/file.dsn > > The MyODBC driver is only on the machine with the DSN not the machine > requiring the access. > > Should this approach work, as it seems to be fine with other databases > > Thanks in advance >

MyODBC problems with file DSN

/file.dsn The MyODBC driver is only on the machine with the DSN not the machine requiring the access. Should this approach work, as it seems to be fine with other databases Thanks in advance John Lodge > John Lodge > Software Engineer > Redwood Technologies Limited > T +[44] (0)1344 304