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

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

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

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

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

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

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