RE: SQL query problem with mysql.

2001-03-05 Thread Aaron Weiker
that with MySQL it is generally not a good idea to do a query with an (*) in it because it could produce speratic data. So by doing a count on a particular column this would alleviate that problem. Aaron Weiker Programmer CISP - Changing Internet Speed Performance Phone: 419.724.5351

RE: weird date behavior

2001-03-01 Thread Aaron Weiker
that it only tries to match the day/month/year w/out the timestamp. I noticed some similar things in Microsoft SQL but haven't worked w/ MySQL enough to know that this is the case. So this is all theory. Aaron Weiker -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent

RE: RE: XML support under mySQL

2001-02-22 Thread Aaron Weiker
I've been stuck working on Microsoft the past year I would do it in a couple days, I've already dome similar to create an XML feed manually for Microsoft SQL using ASP. Aaron Weiker -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 7:42 PM

RE: Microsoft SQL Server linking to MySQL

2001-02-20 Thread Aaron Weiker
This doesn't work, gives the same error. Do we know if Microsoft just doesn't like MySQL? Aaron Weiker Programmer CISP - Changing Internet Speed Performance Phone: 419.724.5351 [EMAIL PROTECTED] Pager: 419.218.0013 http://www.cisp.cc Cell

Microsoft SQL Server linking to MySQL

2001-02-19 Thread Aaron Weiker
I get Invalid object name 'MySQL.mysql.db'. Has anyone done a similar thing and/or have ideas. Aaron Weiker Programmer CISP - Changing Internet Speed Performance Phone: 419.724.5351 [EMAIL PROTECTED] Pager: 419.218.0013 http://www.cisp.cc Cell