Search results for query: *

Thanks, Tony. I've noticed that WHERE "id"=# (some number) gets added to the SQL whenever I pass a query to MySQL and MySQL thinks there's something wrong with it. I've noticed this to be true even in PHP Admin when writing MySQL queries, and it shows the query text. And, yep, Oracle (I guess)...

Hello all. I keep going back and forth on this as to whether it's an Oracle issue or a MySQL. So, honestly, I'll let you decide and will take your advice. Not sure if this is allowed, but I've cross-posted this question in the Oracle: Oracle release - 8 and 8i forum, with a similar message...

Hello all. I keep going back and forth on this as to whether it's an Oracle issue or a MySQL. So, honestly, I'll let you decide and will take your advice. Not sure if this is allowed, but I'm going to cross-post this question in the MySQL forum, with a similar message there that it is...

I guess I owe somebody an apology! I just executed this code (in Oracle):create table tmp20060508 (f1 long); insert into tmp20060508 values ('abc123'); commit; Then I say select * from tmp20060508and it works fine. I get results. My mistake was that I always thought you could not do a select on...

Thanks, Turkbear. Good point. I didn't pay that much attention to the specific error. I guess I assumed it was just like when you try to say select some_long_col from a_table in Oracle. I believe the error (I'm home now so can't retry) was something like...you know I can't remember. Since it's...

Hello all. OK, I know I know: DON'T EVER USE THE LONG DATATYPE. I understand. But here's my situation: I'm accessing data through a db link that's from from a MySQL database. Like SQL Server (I guess), they have this char datatype (I don't know the official name of the datatype in MySQL) that is...

Yes, it is on the same machine. Thanks. Question: Mr. Brooks' suggestion to execute the mysqladmin reload command: There is no chance that by issuing that command that any data will be lost or that a production server will become unavailable is there? Thanks again. -Mike

Hello folks. I am new to MySQL (as you will soon see, no doubt!!). New, as in, like, 2 days new. Can't even hold my eyes straight yet (if you're a parent, you might get that). Our entertainment division uses MySQL as the database of choice for their various websites. They are not...

Hello folks. I am in Oracle Enterprise Manager Console. In the <database_name>: Instance > Sessions > <target session>. I double-click the icon in the far left column and it pulls up the "Edit Session" screen. I go to the "Long Operations" tab and watch the query I'm running. Currently, it says...

hi tom, wow, if that works, you'll be a genius in my book! i'll try tomorrow (tues) at work. thanks a million. -mike

Hello folks! Does anyone know of a way to concatenate two fields when loading via SQL Loader? I have data that looks like: ID,Area_Code,Phone_Number 1,704,1234560 2,305,7891230 3,904,456890 I have a table that has a PHONE column, but no columns for area_code and phone_only. My control file...

Thanks...will do. Let me see, I may have found a work around for now. Thanks again. -Mike

Thanks, Dave. I guess I should have been more specific. I was really looking for some built-in functions!! If anyone knows anything about this, it would be appreciated. Thanks!! -Mike

Hello all. Is there any way to do mortgage calculations in Oracle? Like Principal payment, Interest payment, APR, etc? Thank you. -Mike Kemp

Hello. Does anyone know how to get a report of number of pages printed/day remotely. For example, suppose I have a person in another office telling me they printed 50k pages yesterday, and I want to see for myself that 50k pages went through the printer. Is there a way to do this? Thank you. -Mike

Wow...I don't quite understand your code. Could you possibly give a language-summary? I never got a solution to my problem. If I understand your solution, then that will be what I use. Thanks. -Mike

strongm, So, you're saying that you could just use late binding all the time without ill-effect? if this is the case, it would solve all of our software version issues (we have these issues in other areas as well). thanks. sheco, the thing is, in this case, when there was that missing...

Hello and thanks for reading my question. We have a mixture of Office 2000, Office XP and Office 2003 clients. I just created an application that uses early-binding to send out e-mails via MS Outlook. The entire application fails when it is run on a machine that has a different version of MS...

VBAJedi - Yep, my thoughts exactly. Problem is, though, in order to use the "Fit to Pages" feature, you also have to set: xlWks.pagesetup.zoom=false Then, if you do: msgbox xlwks.pagesetup.zoom, the answer is "false". Obviously, you can't add or multiply "false" by anything. If you try to set...

VBAJedi, Thanks for the help. I already have adjusted the margins as much as I can. What I really need is that number in the little box "Adjust to ##% normal size". Many thanks. -Mike