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 derfloh 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: *

  • Users: LilProgrammerGirl
  • Order by date
  1. LilProgrammerGirl

    Query Size Limitation

    Oh, yes, sorry. The Oracle server I am trying to hit is at our Corporate offices and are read-only. We cannot create procedures on their Oracle Server. I should have explained that, but I didn't think of it. Sorry!!! I had an Oracle Server here, locally, but it's going away and they gave me...
  2. LilProgrammerGirl

    Query Size Limitation

    No, I was saying that it does run on Oracle just fine, but not in SQL Server. SQL Server is where it needs to run. Our Oracle server is going away and I am converting everything from Oracle to SQL :-( What a mess... I just have to break the query down into seperate chunks...bummer!
  3. LilProgrammerGirl

    Query Size Limitation

    A-ha - that's what I was looking for.. thank you SQL Sister. I just threw my query into Word and did a character count and it was 8,525 characters without spaces. It's a monster. 8,000 characters?!?!? How weak! ;-)
  4. LilProgrammerGirl

    Query Size Limitation

    Nope, not using any variables. The error message I get is: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ' SELECT A.ACCOUNT_NUMBER ,H.HOUSE_KEY ,S.NAME ,S.ADDRESS_1 ,S.ADDRESS.
  5. LilProgrammerGirl

    Query Size Limitation

    Is there a better way of escaping the single quotes than how I am doing it above? Hailey
  6. LilProgrammerGirl

    Query Size Limitation

    Hey Phil, Well, what the query would look like as far as single quotes, for example, is this: select * from openquery(server, ' select * from table.a where site = ''1A'' and where key in (''AB'',''AC'',''AD'',''AE'',''AF'') ') Hailey
  7. LilProgrammerGirl

    Query Size Limitation

    ...bigger and will not run anymore. Has anyone ran into this problem before? What can I do to fix it? I would hate to break the query up and for execution and then mesh it together later.... I run the query using: select * from openquery(server, ' here's the query ') Thank you!! Hailey
  8. LilProgrammerGirl

    I need design help...

    Very cool Ristmo! I didn't know you could make a gif's background transparent. That would help me out tremendously because I was planning on providing 3-4 differnt color scheme options in my final presentation for this company and the way it is now..I'd have to recreate the jpg's in all of the...
  9. LilProgrammerGirl

    I need design help...

    ...this company and unfortunately they REALLY like it and insist on using it. I totally agree and everytime I look at that picture I cringe! You'd *think* they'd want to look professional - but they want it to look casual. Go figure.... Also, thanks for all of the suggestions with the image...
  10. LilProgrammerGirl

    I need design help...

    A-ha! I changed my positioning from absolute to relative and it worked! Thanks all!! Hails
  11. LilProgrammerGirl

    I need design help...

    Hmm.. it still didn't work. Here's my css code: #BottomLayer{ position: absolute; margin: 0 auto; text-align: center; width:700px; height: 600px; left: 15px; top: 15px; z-index: 0; background-color: #990000; } #FirstLayer{ position: absolute; margin: 0 auto; text-align: center...
  12. LilProgrammerGirl

    I need design help...

    Alright, I think I got them to look the same in both browsers now... LAST question... how can I get the whole thing to center in the new one? Instead of all be left aligned on the whole screen? Thanks, Hailey
  13. LilProgrammerGirl

    I need design help...

    Okay, I took what you all said and came up with a whole new design. This is the old one: http://69.93.85.115/hailey/template/Trial.htm This is the new one: http://69.93.85.115/NewSite/index.htm Now, I really do think I like the new one better. It will fit on an 800x600 screen better. Now...
  14. LilProgrammerGirl

    No Default Page???

    ...upgraded. ------------------------------------------------------------ Please try this site again later. If you still experience the problem, try contacting the Web site administrator. I have *not* changed anything on the server. Has this ever happened to anyone before?? Thanks, Hailey
  15. LilProgrammerGirl

    I need design help...

    Hey! Thank you Andy for the suggestions! To fix the screen resolution issue - should I just change everything to a % instead of a set pixel? Will that distort anything? Also, how else could I lay that content out if I didn't use a table - a <div> tag?? Thanks again! Hails
  16. LilProgrammerGirl

    I need design help...

    You are right..my resolution is 1024x768. I actually *thought* that was the most common. Thank you for pointing it out! YIKES.. Hailey
  17. LilProgrammerGirl

    I need design help...

    oh boy, the url would help eh? Here it is: http://69.93.85.115/hailey/template/Trial.htm It's on a temporary site right now until I am finished with it. Thanks again for the feedback! Hailey
  18. LilProgrammerGirl

    I need design help...

    Hi all, I have a site that I am working on and I don't think it's flashy enough. I have up what they provided me to publish - which isn't much. I have not started the Map or Contact Us pages yet. Any ideas on how I can spice this up a bit?? Thanks for the feedback... Hailey
  19. LilProgrammerGirl

    Image Disappears

    Very interesting....I turned off all of the ad-blockers I could find and disabled my Norton Antivirus Software and it still gave me the problem. I must be missing an ad-blocker someplace. You guys said that it must be the perfect size .gif for an ad so I increased the pic from the height of 80...
  20. LilProgrammerGirl

    Image Disappears

    I tried to take out all of the white space before and after the image and it didn't do anything. I tried it on a computer at work and it worked just fine. However, it wont work on my home computer on either Mozilla or IE. Here is a link to my page...

Part and Inventory Search

Back
Top