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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by asunpraise

  1. asunpraise

    data comparing inside decode function

    YES! BRILLIANT! WISH I COULD HAVE YOUR BRAIN!
  2. asunpraise

    data comparing inside decode function

    Exactly! My version is 8.1.5. and it's doesn't work.
  3. asunpraise

    data comparing inside decode function

    The following query doesn't work. It seems decode function doesn't like < or > sign inside of it. But I need to compare clients' birth date to another date to get their age then and add them into a age group. Anybody knows how to do this? select client_id, decode(birth_date...
  4. asunpraise

    Connecting to Oracle

    Sorry, I tried, but i don't know why it's not working. At least when this line gets excecuted, Set db = ws.OpenDatabase(&quot;&quot;, False, False, strConnect) Data source window pops up, right?
  5. asunpraise

    Connecting to Oracle

    I need to import data from Oracle database to Access, and I'm already done with it. The connection variable is: CON = &quot;IN RPD[ODBC;SERVER=aserver;UID=DDDD;PWD=XXXXX]&quot; The problem is that I have to import more than one tables, and every time when I have sql statement such as: 'COPY...
  6. asunpraise

    Connecting to Oracle

    I need to import data from Oracle database to Access, and I'm already done with it. The connection variable is: CON = &quot;IN RPD[ODBC;SERVER=aserver;UID=DDDD;PWD=XXXXX]&quot; The problem is that I have to import more than one tables, and every time when I have sql statement such as: 'COPY...
  7. asunpraise

    Passing variable to the third form

    Sorry, it doesn't seem to work. Actually, I would need the accountName throughout the pages, so it will be more than 3 pages using it. Shall I define it as global variable? I don't know how global variables work at all.
  8. asunpraise

    Passing variable to the third form

    To simplify my purpose, I have three forms here: 1. contains input field with accountName <form method=&quot;POST&quot; action=&quot;choose.php&quot;> 2. choose.php, this only processes the data and redirects to other pages according to different account names, this is one of them...
  9. asunpraise

    Help using javascript confirm() function with php

    Sorry to bother you guys, i just figured it out. I simply put <A href=\&quot;delete.php?pid=&quot;.$row[&quot;pid&quot;].&quot;\&quot; onClick=\&quot;javascript:return confirm('Are you sure you want to delete your record?)\&quot;></a> and it worked. thanks anyways. Lea
  10. asunpraise

    Help using javascript confirm() function with php

    I need exactly the same thing here. But sorry I don't know anything about Javascript, so i don't know how to call onclick. Furthermore, instead of submit button, what i have is a delete image, if user clicks on the image, it calls another page which deletes the record, like: echo &quot; <A...
  11. asunpraise

    convert text to hyperlink

    Thank you so much for the reply, the function works great except it doesn't include symbols. If i enter http://www.eng.fsu.edu/~aaa, it only convert http://www.eng.fsu.edu/ to hyperlink. I'm a newbie to PHP and none of the books i got discuss this in detail. I greatly appreciate your help and if...
  12. asunpraise

    deleting entry at an ID# in table, but also deleting ID#

    I had a similar problem. I had to delete records and display them in sequence without break, like 1,2,3,4,5,6,7.....continuously. Can I make up an arry, so that every time when while ($row=mysql_fetch_array($queryresult)) echo &quot; <td width=10% align=center...
  13. asunpraise

    convert text to hyperlink

    I was kinda hoping there could be a function to do this. I won't know what user will input. somewhat string parsing may be involved. Thank you, Lea
  14. asunpraise

    uploading and downloading file questions

    You don't need to bother, just link to file. Browsers will pop up windows to allow users to save files.
  15. asunpraise

    convert text to hyperlink

    Anyone knows what script is like to automatically change a URL to hyperlink so that when a user types a URL in the text field, it changes into hyperlink, like this: http://google.com Thanks, Lea

Part and Inventory Search

Back
Top