RE: SQL query problem with mysql.

2001-03-05 Thread Aaron Weiker
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.

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 PROTEC

RE: RE: XML support under mySQL

2001-02-22 Thread Aaron Weiker
to me about how hard this is. If it wasn't for the fact 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

RE: XML support under mySQL

2001-02-21 Thread Aaron Weiker
e to compete feature to feature against the other DB's that are out there. Aaron Weiker Programmer CISP - Changing Internet Speed & Performance Phone: 419.724.5351 [EMAIL PROTECTED] Pager: 419.218.0013 http://www.cisp.cc Cell:419.304.0323

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://ww

Microsoft SQL Server linking to MySQL

2001-02-19 Thread Aaron Weiker
or message 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