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 Rhinorhino 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: SidUK
  • Order by date
  1. SidUK

    Redirect corruption - ? to :1

    For anyone who find the same thing, I have now tracked this down to how much other code is previously in the procedure. For some reason, DBA studio was substituting a :1 for a question mark when there were 10 table updates before the redirect (owa_util, but it also did the same thing with an...
  2. SidUK

    Redirect corruption - ? to :1

    Hi We use pl/sql packages to interact with an 8.1.7 db, and every now and then it replaces question marks in owa_util redirect_url statements with ':1'. The package is valid in PL/SQL still (the :1 basically being html), and although you can compile the packages having subsituted a "?" and in...
  3. SidUK

    Show null results in SQL loop

    Thanks Guys - much appreciated. Sid
  4. SidUK

    Show null results in SQL loop

    Thanks very much for your efforts Mufasa - especially given the time in the morning. Kind regards, Sid
  5. SidUK

    Show null results in SQL loop

    Thanks for that Mufasa If the SQL was: select a.country,count(b.country)Count from country a, Organisation_type b where a.id = b.country(+) and b.type='reseller' group by a.country Could you do something similar? Kind regards, Sid
  6. SidUK

    Show null results in SQL loop

    Sorry! Basically, I think my problem boils down to: Country table: ID Country 1 UK 2 US Organisation_type table: Country Type 1 Reseller 1 Reseller Select country.country, count(ot.type) from organisation_type ot, country where ot.country = country.id group by country.country...
  7. SidUK

    Show null results in SQL loop

    Hi Mufasa On the sample of table contents, the user can select any table from a web page drop down box, and then the fields that relate to the table they have selected are displayed in another drop down box. This is done 3 times, one for the values that are needed in the rows (row_name and...
  8. SidUK

    Show null results in SQL loop

    Hi - I suspect this is a basic SQL issue. I'm trying to create a crosstab from three sets of tables and fields that are selected by the user. 1, the columns, 2, the rows and 3, the values. I am using a three dynamic SQL cursors, one after the other, to show: First, the columns (simple group...
  9. SidUK

    ORA-12575 - TNS Packet Writer Failure

    Hi - I'm trying to log onto our database server using Enterprise Manager. This is something I have been able to do without a problem before. But, we have changed our IP addresses. I am logging on using the IP address, the port, and the database name. I am getting the TNS error code noted...
  10. SidUK

    Get around Outlook XP security update

    Thanks - will look into this, but perhaps I could use that idea and sendkeys from the VBA script (if VB still does this!). Perhaps worth a try... Regards, Andrew
  11. SidUK

    Get around OLXP Security Update

    Thanks Matt - I'm not running Outlook on Exchange, but will try the ideas behind the faq and and see if they work! Regs, Andrew
  12. SidUK

    Get around OLXP Security Update

    I had a VBA/VB script that sent HTML e-mails to Outlook 98 to my customers, and I have now had to install Outlook XP. This seems to have Outlook security update automatically applied, and each time I try and use my VBA script, Outlook does the 'You are trying access...' dialogue, followed by a...
  13. SidUK

    Get around Outlook XP security update

    Hi I had a VBA script that sent HTML e-mails from Access 97 to Outlook 98 to my customers, and I have now had to install Outlook XP. This seems to have Outlook security update automatically applied, and each time I try and use my VBA script, Outlook does the 'You are trying access...'...
  14. SidUK

    Webdb Sites - worth doing?

    Hiya To date I've created several apps with small numbers of users. In the system I have used, each user has a separate user account in Oracle 8.1.5 and the username is fed through to access to different levels of data using the USER. I've used raw webdb reports and forms, and PL/SQL scripts...
  15. SidUK

    Importing files from 8i - strip away the padding

    A customer has sent me some files he has exported (actually SQL outputs) from 8i. He says he has delimited them with a semi-colon, but they are effectively fixed-width. The records are padded with spaces. This has made the files massive - one of them is 2GB, others are around 1GB - they should...

Part and Inventory Search

Back
Top