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!

  • Congratulations Mike Lewis 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. RycherX

    database error when copying asp directory

    Folder name changed, but there is no reference to the name of the folder. So that shouldn't matter.
  2. RycherX

    database error when copying asp directory

    It is the same connection. I am merely making a copy of a working ASP directory and renaming it. The global.asa file is the same as are all the other files.
  3. RycherX

    database error when copying asp directory

    I have a working asp directory on my web server. I simply do a copy of that directory and renaming it. When I pull it up in my browser, asp pages require a database connection will error with the below. I don't understand why merely copying the directory is a disruption...
  4. RycherX

    How should I start

    I have 2 tables table1 fields -------------- quote status I want to set up a table table2 fields --------------- quote status date In the event that table1.status changes, I want a transaction log in table2. Any suggestions to point to the right direction?
  5. RycherX

    ORA_01722 ERROR.

    I went ahead and ran the following select wavr01 from proddta.F4801 where WASRST = '60' and WADCTO = 'TF' and WAMMCU = lpad('101',12,' ') and wavr01 <> lpad(' ',25,' ') ********************** Only 40 records popped up and saw 2 records that were foul. I corrected the bad data since it has to be...
  6. RycherX

    ORA_01722 ERROR.

    select to_number(wavr01) Parent, wadoco child, 'C' Type from proddta.F4801 where WASRST = '60' and WADCTO = 'TF' and WAMMCU = lpad('101',12,' ') and wavr01 <> lpad(' ',25,' ') I get the error.
  7. RycherX

    ORA_01722 ERROR.

    I'm getting the ERROR: ORA-01722: invalid number How do I find the record in my view that causing the error? Obviously there has to be some alpha letters somewhere.
  8. RycherX

    How do I create a field of years

    I want to go about 5 years back. Purpose is to feed a drop down list box on a web page. I'll be Frontpage tool to connect to the Oracle DB Table or View.
  9. RycherX

    How do I create a field of years

    I want a table with one field. I want values to be the current year, the year before, and the year before that...etc.... I want this table to be updated on the fly. I have the following, but these are in separate fields which I don't want happen. select to_char(sysdate, 'YYYY')...
  10. RycherX

    Locked out Administrator

    I am administrator on when logging onto the "Crystal Management Console". For some reason I am locked out. It says "All system 0's concurrent licenses are in use at this time or your system's license key has expired" I am suppose to consult the system administrator. The problem is I am the...
  11. RycherX

    pane window that user can paste excel columns into

    Is it possible to display JTABLE with JSP? How would I call JTABLE to do a display on the browser?
  12. RycherX

    pane window that user can paste excel columns into

    I'm confused
  13. RycherX

    pane window that user can paste excel columns into

    I want my java application to display a FORM where a user can paste from an excel sheet 2 columns onto a pane on the java application form. After pasting 2 columns of as few as one row to as many as a hundred rows, user will hit the submit button. This will ultimately update a table in oracle...
  14. RycherX

    Checking Array values

    When I use length, it gives me the capacity of the BlockList. Is there any way to check if an array contains values that are not equal to "nothing". Dim BlockList as String reDim BlockList(50) if BlockList.length > 0 then end if
  15. RycherX

    Array length

    When I use length, it gives me the capacity of the BlockList. Is there any way to check if an array contains values that are not equal to "nothing". Dim BlockList() as String if BlockList.length > 0 then end if
  16. RycherX

    exit more than one loop

    How do I exit 2 loops? I want to be able to exit the Do loop and the outer For loop. Is that possible? How do I do that? For i = i To UBound(tContents) s = Trim(tContents(i)) 'Check for end of file If Mid(s, 1, 5) = "*SPC*" Then ReDim...
  17. RycherX

    removing carriage returns

    Can I through a select statement takeout all the carriage returns within a field when I retrieve it?
  18. RycherX

    refreshing report data

    I generated a ~.qry file that taps into a database. I have a report based off of that ~.qry file. I've been scheduling the report every morning. First, I open the ~.qry file with SQL designer and then press the refresh button followed by the save button. I then open my report file and press the...
  19. RycherX

    script doesn't work in Netscape

    What do I have to do here to make it both IE and Netscape compatible? function Blank_TextField_Validator() { // Check the value of the element named EMPNUM // from the form named Main if (Main.EMPNUM.value == &quot;&quot;) { // If null display...
  20. RycherX

    Help in passing values

    I have a drop down list box name ListBoxURL in my JSP. The variable Choice is read into my javascript correctly only if it is one word. If the user makes a selection choice that has 2 words like &quot;James No&quot;, only James will be read in as the Choice. How can I fix this problem? var...

Part and Inventory Search

Back
Top