Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mike777

    Accessing MySQL data via ODBC and Oracle's Heterogenous Services

    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)...
  2. mike777

    Accessing MySQL data via ODBC and Oracle's Heterogenous Services

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

    Database link, heterogeneous services

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

    LONG Datatype - Hold it!! Don't tell me not to use it :-)

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

    LONG Datatype - Hold it!! Don't tell me not to use it :-)

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

    LONG Datatype - Hold it!! Don't tell me not to use it :-)

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

    Cannot log on via command prompt.

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

    Cannot log on via command prompt.

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

    Current step in execution plan

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

    SQL Loader...concatenate fields

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

    SQL Loader...concatenate fields

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

    Mortgage calculations in Oracle

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

    Mortgage calculations in Oracle

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

    Mortgage calculations in Oracle

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

    Reports from printer data, print server

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

    Obtain scale of result of fittopagestall, wide

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

    Late vs. Early Binding

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

    Late vs. Early Binding

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

    Obtain scale of result of fittopagestall, wide

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

    Obtain scale of result of fittopagestall, wide

    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

Part and Inventory Search

Back
Top