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 strongm 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: yodaa
  • Order by date
  1. yodaa

    Discard target="_top" for external page in iframe

    cLFlaVA, All files are on the same server. I want to replace the current index file with an index file containing the tool bar. My new index page code <html> <head> <title>UNITS tool bar test 3..</title> <meta http-equiv="content-type" content="text/html;charset=utf-8" />...
  2. yodaa

    Discard target=&quot;_top&quot; for external page in iframe

    cLFlaVA, There is a javascript in the head setting the target in the following way (PopNew is the ID of a check box) if( document.form1.PopNew.checked ) document.form1.target = "NewWindow"; else document.form1.target = "_top"; The javascript also sets PopNew to true if the page...
  3. yodaa

    Discard target=&quot;_top&quot; for external page in iframe

    Hi, I wish to create a basic page using an iframe. The iframe will contain a login page for a system we have purchased and can't modify. When you hit the login button, the welcome page will load on top of the page because since the target is set to top. The reason for why I wish to use an...
  4. yodaa

    Discard target=&quot;_top&quot; in external page in iframe

    Hi, I wish to create a basic page using an iframe. The iframe will contain a login page for a system we have purchased and can't modify. When you hit the login button, the welcome page will load on top of the page because since the target is set to top. The reason for why I wish to use an...
  5. yodaa

    Scheduled reports stuck in &quot;Running&quot; state

    MJRBIM, Thanks for the reply. I tried patching up CE, but it didn't solve the problem. So my next approach was to uninstall CR and CE, that worked fine. But when I tried to install CE again, it detected MS SQL Server on the machine. For some reason, I don't have the username/password to be able...
  6. yodaa

    Scheduled reports stuck in &quot;Running&quot; state

    Hi, I'm using CR Enterprise 10 on a server to schedule a number of reports. As of yesterday the reports haven't run, the're stuck in "Running" mode. I can't see any messages that could be of help. This has worked fine for about a month. The only change on the server is that I the day before...
  7. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    Yeah, sorry about that. I didn't look at the whole picture there. Thanks again guys, will try this first thing at work tomorrow. /yodaa
  8. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    Beilwish, Sweet.. Did not know you could use negation in substr(). That will make my select statement more clean. I can't create a new table as I need to have the 4000 character capacity. Thanks for the help, all of you. /yodaa
  9. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    Solved it! select "Field_A","Field_B",substr(case when length("Field_C") < 256 then substr("Field_C",1,length("Field_C")) when length("Field_C") > 255 then substr("Field_C",length("Field_C")-255,length("Field_C")) end,1,255) as NewName from "Table_A" Thanks for all the help. /yodaa
  10. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    SantaMufasa, Have you had the chance to look at the VARCHAR2(4000) issue? Thankful for any help. /yodaa
  11. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    SantaMufasa, If I don't use the double quotes I get syntax errors. That's the only reason for why I'm using it. I'll see if there's a way of getting rid of those, thanks for noticing it. My original code will never return a string > 255. The thing forcing me to use the case statement is that I...
  12. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    hoinz, thanks for the quick help.. I've tried the below query to create the view and I still get a VARCHAR(4000). I'm in a catch-22 situation and don't know where to go from here. select "Field_A","Field_B",case when length("Field_C") < 200 then "Field_C" when length("Field_C") > 199...
  13. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    I have created a View in Oracle 10g where one of the columns is a VARCHAR2(4000). I want to change that VARCHAR2 column to a VARCHAR2(255) because I'm having problems with using the field in a formula in Crystal Reports 8 since CR8 can't use fields > 255 characters in formulas. Is it possible...
  14. yodaa

    Request propagation (multimaster replication) from trigger?

    I'm looking for information regarding multimaster replication in Oracle 10g. I've found out that asynchronous replication would suit our needs well. The exception is the data conflict that occurs when two users at the same time creates a new record in the exact same table in their local...
  15. yodaa

    Trigger with embedded select that returns multiple rows

    Hi, I have a problem with a trigger. Three tables are invovled in the process. Table a pID, aID Table b pID, bID, bNum, bType The tables above are the source tables and shall be used to populate Table c. Table c should contain values from the tables above as seen below. Table c pID, aID, bID...
  16. yodaa

    Full path of link to relative

    Hi, I'm having som diffulties with links here. Is there a way of taking the full path of a link: /a/b/c/d/e/f/link > /a/b/c/link_target and make it relative? Thanks, yodaa
  17. yodaa

    CR 10 to 9 - doable, but HOW?

    Ido, The system supports CR 9 reports according to the vendor. That's why it's so frustrating when I can't view a CR 9/10 report. This is why I also want to convert to 9, to make sure that the sys really does support CR 9. Thanks, yodaa
  18. yodaa

    CR 10 to 9 - doable, but HOW?

    Gary, Thank you very much for clearing that out, atleast now I know how to go forward. Thanks, yodaa
  19. yodaa

    CR 10 to 9 - doable, but HOW?

    We have purchased a bug tracking system (DevTrack) where you can specify a number of custom made reports. DevTrack supported only version 8 of CR up til a month ago, now they support reports with a version up to 9, thanks God for that. We have two licenses for CR, one is for CR 8 to support our...
  20. yodaa

    CR 10 to 9 - doable, but HOW?

    Ido, It doen't work with using a CR 10 report as is in my system. I checked the properties of the report and it has a version tag with the value 10. I think that's why my system rejects this report. I'm beginning to think that the only way I can get a report in version 9 is to open it in CR 9...

Part and Inventory Search

Back
Top