Re: Differences between MySQLs?
Another quick thought...does MySQL have row level security? Its possible that your second datasource has given you read access to the table, but not the rows in the database. This has caught me in Oracle before. Allen On 24-Mar-10, at 2:30 PM, denstar wrote: > > Are they the same versions of MySQL on both? > > Have you tried doing a LIKE instead of the "="? Maybe throw a TRIM in > there, just in case, or else do the LIKE up with, like, > '%theFirstFewChars%' or some such? > > :den > > -- > All generous minds have a horror of what are commonly called "Facts". > They are the brute beasts of the intellectual domain. > Thomas Hobbes > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
On Wed, Mar 24, 2010 at 2:30 PM, denstar wrote: > > Are they the same versions of MySQL on both? Yup. > Have you tried doing a LIKE instead of the "="? Maybe throw a TRIM in > there, just in case, or else do the LIKE up with, like, > '%theFirstFewChars%' or some such? I haven't tried that, but considering it's this one page and I loop over a few queries, my final thought is that perhaps they have some flow control limiter that causes the DB not to return results in some situations. > :den > > -- > All generous minds have a horror of what are commonly called "Facts". > They are the brute beasts of the intellectual domain. > Thomas Hobbes > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
Are they the same versions of MySQL on both? Have you tried doing a LIKE instead of the "="? Maybe throw a TRIM in there, just in case, or else do the LIKE up with, like, '%theFirstFewChars%' or some such? :den -- All generous minds have a horror of what are commonly called "Facts". They are the brute beasts of the intellectual domain. Thomas Hobbes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
Well, I use a hosting company, so stuff like that is out of something I can do. :) I'll forward your suggestion along though. :) Thanks. On Wed, Mar 24, 2010 at 1:57 PM, Won Lee wrote: > > I'm really trying hard to remember...but I think the connector is part of > the db string. Open up each datasource in cfadmin. It also might be > installed to your JDK_Path/lib/ext. I might be off, both in pointing you > towards the JDBC connector and how to check which version you have. I have > no experience actually handling the connector. I just know that when my > data sets started to yield unexpected data I would have the server admins > check the connectors and often it was the cause. > > > > On Wed, Mar 24, 2010 at 4:17 PM, Phillip Vector > wrote: > >> >> Datasource is correct and the application datasource is correct. >> >> I have no way to confirm the JDBC connectors. >> >> On Wed, Mar 24, 2010 at 12:37 PM, Won Lee wrote: >> > >> > 1) check the datasource in cf admin. >> > 2) make sure the JDBC connectors are the same. In your case it doesn't >> seem >> > like it will be the issue but I would eliminate it as a possibility. >> > 3) check the application.dsn (or whatever you named it). Make sure it is >> > correct by cfdumping it. >> > >> > W >> > >> > On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector >> > wrote: >> > >> >> >> >> When I run this on my server.. >> >> >> >> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' >> >> >> >> I get 6 results... >> >> >> >> This is a local Dev server I have set up. >> >> >> >> When i run it at my hosting company, I get 0 results for the same >> >> exact query. I go in and my external database program confirms the >> >> records are in there. The page works fine locally, but on the live >> >> site, it doesn't. >> >> >> >> Before I make a ticket, can anyone confirm perhaps a setting they >> >> heard of or some such that might be responsible or does anyone have >> >> any additional troubleshooting steps I may be missing? >> >> >> >> >> > >> > >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
No. The live database table is exactly the same as the dev table (it was copied over directly). I'm just going to ask support and perhaps they will be able to help. Thanks anyway. :) On Wed, Mar 24, 2010 at 1:54 PM, G Allen R Souliere wrote: > > Any chance that the two databases are not identical? Perhaps the column > type is not the same? > > I imagine MySQL has something similar to Oracle: there are VARCHAR and > CHAR (fixed width) columns. A query that would work fine against a > varchar column would likely fail against a char column because of the > spaces padded at the end of the values in the column. > > Just a thought. > > Allen > > Phillip Vector wrote: >> Both are windows, but I made sure anyway. Nope. That's not it. >> >> >> >> On Wed, Mar 24, 2010 at 12:38 PM, Andy Matthews >> wrote: >> >>> Could be a case sensitivity issue. What's the OS of you, and of your host? >>> On *nix systems table names are case sensitive. >>> >>> -Original Message- >>> From: Phillip Vector [mailto:vec...@mostdeadlygame.com] >>> Sent: Wednesday, March 24, 2010 2:03 PM >>> To: cf-talk >>> Subject: Differences between MySQLs? >>> >>> >>> When I run this on my server.. >>> >>> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' >>> >>> I get 6 results... >>> >>> This is a local Dev server I have set up. >>> >>> When i run it at my hosting company, I get 0 results for the same exact >>> query. I go in and my external database program confirms the records are in >>> there. The page works fine locally, but on the live site, it doesn't. >>> >>> Before I make a ticket, can anyone confirm perhaps a setting they heard of >>> or some such that might be responsible or does anyone have any additional >>> troubleshooting steps I may be missing? >>> >>> >>> >>> >>> >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
No records at all. But on the local server, yes. Verified both databases are exactly alike. On Wed, Mar 24, 2010 at 12:25 PM, Dorioo wrote: > > any caching on your query? > > - Gabriel > > On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector > wrote: >> >> When I run this on my server.. >> >> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' >> >> I get 6 results... >> >> This is a local Dev server I have set up. >> >> When i run it at my hosting company, I get 0 results for the same >> exact query. I go in and my external database program confirms the >> records are in there. The page works fine locally, but on the live >> site, it doesn't. >> >> Before I make a ticket, can anyone confirm perhaps a setting they >> heard of or some such that might be responsible or does anyone have >> any additional troubleshooting steps I may be missing? >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
I'm really trying hard to remember...but I think the connector is part of the db string. Open up each datasource in cfadmin. It also might be installed to your JDK_Path/lib/ext. I might be off, both in pointing you towards the JDBC connector and how to check which version you have. I have no experience actually handling the connector. I just know that when my data sets started to yield unexpected data I would have the server admins check the connectors and often it was the cause. On Wed, Mar 24, 2010 at 4:17 PM, Phillip Vector wrote: > > Datasource is correct and the application datasource is correct. > > I have no way to confirm the JDBC connectors. > > On Wed, Mar 24, 2010 at 12:37 PM, Won Lee wrote: > > > > 1) check the datasource in cf admin. > > 2) make sure the JDBC connectors are the same. In your case it doesn't > seem > > like it will be the issue but I would eliminate it as a possibility. > > 3) check the application.dsn (or whatever you named it). Make sure it is > > correct by cfdumping it. > > > > W > > > > On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector > > wrote: > > > >> > >> When I run this on my server.. > >> > >> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' > >> > >> I get 6 results... > >> > >> This is a local Dev server I have set up. > >> > >> When i run it at my hosting company, I get 0 results for the same > >> exact query. I go in and my external database program confirms the > >> records are in there. The page works fine locally, but on the live > >> site, it doesn't. > >> > >> Before I make a ticket, can anyone confirm perhaps a setting they > >> heard of or some such that might be responsible or does anyone have > >> any additional troubleshooting steps I may be missing? > >> > >> > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
Any chance that the two databases are not identical? Perhaps the column type is not the same? I imagine MySQL has something similar to Oracle: there are VARCHAR and CHAR (fixed width) columns. A query that would work fine against a varchar column would likely fail against a char column because of the spaces padded at the end of the values in the column. Just a thought. Allen Phillip Vector wrote: > Both are windows, but I made sure anyway. Nope. That's not it. > > > > On Wed, Mar 24, 2010 at 12:38 PM, Andy Matthews > wrote: > >> Could be a case sensitivity issue. What's the OS of you, and of your host? >> On *nix systems table names are case sensitive. >> >> -Original Message- >> From: Phillip Vector [mailto:vec...@mostdeadlygame.com] >> Sent: Wednesday, March 24, 2010 2:03 PM >> To: cf-talk >> Subject: Differences between MySQLs? >> >> >> When I run this on my server.. >> >> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' >> >> I get 6 results... >> >> This is a local Dev server I have set up. >> >> When i run it at my hosting company, I get 0 results for the same exact >> query. I go in and my external database program confirms the records are in >> there. The page works fine locally, but on the live site, it doesn't. >> >> Before I make a ticket, can anyone confirm perhaps a setting they heard of >> or some such that might be responsible or does anyone have any additional >> troubleshooting steps I may be missing? >> >> >> >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
I should point out that in every other area of the site, the DB works perfectly. The only think I can think of is that the code is looped around 3 cfloops (I know.. It's not a good way to program it, but it's what I was able to come up with). Can CF Admin set a limit on the number of loops within themselves? On Wed, Mar 24, 2010 at 12:38 PM, Andy Matthews wrote: > > Could be a case sensitivity issue. What's the OS of you, and of your host? > On *nix systems table names are case sensitive. > > -Original Message- > From: Phillip Vector [mailto:vec...@mostdeadlygame.com] > Sent: Wednesday, March 24, 2010 2:03 PM > To: cf-talk > Subject: Differences between MySQLs? > > > When I run this on my server.. > > SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' > > I get 6 results... > > This is a local Dev server I have set up. > > When i run it at my hosting company, I get 0 results for the same exact > query. I go in and my external database program confirms the records are in > there. The page works fine locally, but on the live site, it doesn't. > > Before I make a ticket, can anyone confirm perhaps a setting they heard of > or some such that might be responsible or does anyone have any additional > troubleshooting steps I may be missing? > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
Both are windows, but I made sure anyway. Nope. That's not it. On Wed, Mar 24, 2010 at 12:38 PM, Andy Matthews wrote: > > Could be a case sensitivity issue. What's the OS of you, and of your host? > On *nix systems table names are case sensitive. > > -Original Message- > From: Phillip Vector [mailto:vec...@mostdeadlygame.com] > Sent: Wednesday, March 24, 2010 2:03 PM > To: cf-talk > Subject: Differences between MySQLs? > > > When I run this on my server.. > > SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' > > I get 6 results... > > This is a local Dev server I have set up. > > When i run it at my hosting company, I get 0 results for the same exact > query. I go in and my external database program confirms the records are in > there. The page works fine locally, but on the live site, it doesn't. > > Before I make a ticket, can anyone confirm perhaps a setting they heard of > or some such that might be responsible or does anyone have any additional > troubleshooting steps I may be missing? > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
Datasource is correct and the application datasource is correct. I have no way to confirm the JDBC connectors. On Wed, Mar 24, 2010 at 12:37 PM, Won Lee wrote: > > 1) check the datasource in cf admin. > 2) make sure the JDBC connectors are the same. In your case it doesn't seem > like it will be the issue but I would eliminate it as a possibility. > 3) check the application.dsn (or whatever you named it). Make sure it is > correct by cfdumping it. > > W > > On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector > wrote: > >> >> When I run this on my server.. >> >> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' >> >> I get 6 results... >> >> This is a local Dev server I have set up. >> >> When i run it at my hosting company, I get 0 results for the same >> exact query. I go in and my external database program confirms the >> records are in there. The page works fine locally, but on the live >> site, it doesn't. >> >> Before I make a ticket, can anyone confirm perhaps a setting they >> heard of or some such that might be responsible or does anyone have >> any additional troubleshooting steps I may be missing? >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Differences between MySQLs?
Could be a case sensitivity issue. What's the OS of you, and of your host? On *nix systems table names are case sensitive. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Wednesday, March 24, 2010 2:03 PM To: cf-talk Subject: Differences between MySQLs? When I run this on my server.. SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' I get 6 results... This is a local Dev server I have set up. When i run it at my hosting company, I get 0 results for the same exact query. I go in and my external database program confirms the records are in there. The page works fine locally, but on the live site, it doesn't. Before I make a ticket, can anyone confirm perhaps a setting they heard of or some such that might be responsible or does anyone have any additional troubleshooting steps I may be missing? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
1) check the datasource in cf admin. 2) make sure the JDBC connectors are the same. In your case it doesn't seem like it will be the issue but I would eliminate it as a possibility. 3) check the application.dsn (or whatever you named it). Make sure it is correct by cfdumping it. W On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector wrote: > > When I run this on my server.. > > SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' > > I get 6 results... > > This is a local Dev server I have set up. > > When i run it at my hosting company, I get 0 results for the same > exact query. I go in and my external database program confirms the > records are in there. The page works fine locally, but on the live > site, it doesn't. > > Before I make a ticket, can anyone confirm perhaps a setting they > heard of or some such that might be responsible or does anyone have > any additional troubleshooting steps I may be missing? > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
any caching on your query? - Gabriel On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector wrote: > > When I run this on my server.. > > SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' > > I get 6 results... > > This is a local Dev server I have set up. > > When i run it at my hosting company, I get 0 results for the same > exact query. I go in and my external database program confirms the > records are in there. The page works fine locally, but on the live > site, it doesn't. > > Before I make a ticket, can anyone confirm perhaps a setting they > heard of or some such that might be responsible or does anyone have > any additional troubleshooting steps I may be missing? > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Differences between MySQLs?
When I run this on my server.. SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' I get 6 results... This is a local Dev server I have set up. When i run it at my hosting company, I get 0 results for the same exact query. I go in and my external database program confirms the records are in there. The page works fine locally, but on the live site, it doesn't. Before I make a ticket, can anyone confirm perhaps a setting they heard of or some such that might be responsible or does anyone have any additional troubleshooting steps I may be missing? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm