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 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 a LONG-datatype column. The...

...when you try to select a column from a table when the column doesn't exist in the table. In this case, I know the column name is good (from select * in MS Access), and when I commented out the column from the select statement in Oracle, the query worked. It was at that point that I rechecked...

...(I guess), they have this char datatype (I don't know the official name of the datatype in MySQL) that is 2G in length I guess. I did aselect * from all_tab_columns@my_db_link_to_MySQLand under the data_type column it says "LONG" and under the data_length column it says 2,147,483,647. I don't...

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

...then use SQL to transfer the data over to the final table. Or, I could just add the columns to the existing table, then drop them. But I'm wondering if there's a couple steps I could save with some fancy SQL*Loader code. I checked on the web, and came up empty-handed. Thanks for your help...

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...

...go into Print Preview to view the document, then go into Setup, you will see that the "Adjust to ##% normal size" actually has a number in it. That's the number I need, so I can set xlwks.pagesetup.zoom=[this number] * 1.05, etc. It's a catch-22 situation. Do you see my dilemma? Thanks again...

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