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

  1. mts176

    SCORM

    Does anybody know how to connect to the SCORM API or any API through ASP?
  2. mts176

    Need to get the href from XML

    Thanks tsuji this is what I needed. Have a star.
  3. mts176

    Need to get the href from XML

    I am trying to parse an XML file with the following code Set objXML = Server.CreateObject("Microsoft.XMLDOM") objXML.async = False objXML.Load (Server.MapPath("imsmanifest.xml")) Set objLst = objXML.getElementsByTagName("resource") For i = 0 to (objLst.length - 1) response.write...
  4. mts176

    Get 5 previous classes/class dates

    Thank you very much Beilstwh, that is what I am looking for. It works like a charm.
  5. mts176

    Get 5 previous classes/class dates

    I am getting all classes that occur/start either today or sometime in the future. I want to get all of those classes plus the 5 previous classes no matter the date. ex: there are 2 classes either today or in the future Start date Class Name 5/16/06 How to Use a Phone 5/20/06...
  6. mts176

    Get 5 previous classes/class dates

    I am not sure if I will explain this correctly but here goes. Our website has a functionality that will allow certain users to schedule classes. We also have a feature that allows users to add people to these classes. On this particular page we have a query that gets all classes that have a...
  7. mts176

    If q_rec.myfield = null

    Thank you all I got it to work. Here is the code I used. declare nextclassID number; nextgroupID number; nextroomID number; newAddedBy number; newLastEditBy number; oldLastEditBy number; oldAddedBy number; CURSOR q IS select class_id, course_id, class_date, room_id, unique_id, webevent_id...
  8. mts176

    If q_rec.myfield = null

    I just tried the "NVL" and got an error message box: ORA-01403: no data found ORA-06512: as line 27
  9. mts176

    If q_rec.myfield = null

    This is the code that I am trying to use declare nextclassID number; nextgroupID number; nextroomID number; newAddedBy number; newLastEditBy number; CURSOR q IS select class_id, course_id, class_date, room_id, unique_id, webevent_id, start_time, end_time, cancelled, class_recur_id, comments...
  10. mts176

    If q_rec.myfield = null

    I believe you have helped me before SantaMufasa and I am always amazed at the quickness of your responses and your knowledge of the subject matter. Sometimes 1 star just doesn't seem enough. I thank you for that in depth explanation of oracles null. I tried to use the "IF <expression> IS...
  11. mts176

    If q_rec.myfield = null

    I am trying to write a script that when returned it checks a certain field. If that field is null then I would put an id into a variable. If the field is not null then I would do a "select into" myvariable from mytable where somefield = q_rec.somefield. declare nextclassID number; nextgroupID...
  12. mts176

    Trim table data to the right 4 chars i.e. right(PIN,4)

    Works like a charm. Thank you very much. That was the quickest response I have had. I was a little worried that I wouldn't be able to get this done in a timely fashion. Thank you once again SantaMufasa.
  13. mts176

    Trim table data to the right 4 chars i.e. right(PIN,4)

    I am trying to write a query with a few where clauses in it. One of the clauses I want to compare the right 4 chars/nums with a known 4 digit number. Much like the Right function in ASP Here is my query Select * from users Where USERNAME = 'myuser' AND (DOB = to_date('8/6/1964','mm/dd/yyyy')...
  14. mts176

    If Len(iOptionID)&lt;1 OR IsNumeric(iOptionID)...........

    Give this a try if (iOptionID = "" or isNull(iOptionID)) and (Len(iOptionID) = 0 or not IsNumeric(iOptionID)) then Redirect else Do your code End if
  15. mts176

    If Len(iOptionID)&lt;1 OR IsNumeric(iOptionID)...........

    Try adding an not isNull(iOptionID) in your if statement.
  16. mts176

    Running oracle function in ASP

    That will be one of the major issues with version 2. Right now we are not equipped to host this ourselves. But of anything next version we are going to need admin rights to the database. There are 3 of us in the office that have been a dba at one time or another in our careers, but when you...
  17. mts176

    Running oracle function in ASP

    I know we could do that we discussed it, but my boss wants as much as possible done in the database. This is the first version of the application, it is a compilation of many different developers over a long period of time. The next version is going to be rewritten and streamlined. My boss...
  18. mts176

    Running oracle function in ASP

    This is for a grading system. Each course is going to have its own rules for grades. I know that eventually we will get some grading systems that will be the same but we just want to make sure we have the easiest way to add new "functions" as possible. Our web hosting provider wouldn't trust...
  19. mts176

    Running oracle function in ASP

    I have a need to store an oracle function in a CLOB. When a user hits a certain page I want to pull the function out of the CLOB and run it through an ASP page. How do I go about doing this? I have been trying to get it to run for a while now, but I just can't get it to return anything. A...
  20. mts176

    Regular Expression For Email validation with \+

    This is the code I am using if(email.length <= 0) { return true; } var splitted = email.match("^(.+)@(.+)$"); if(splitted == null) return false; if(splitted[1] != null ) { var regexp_user=/^\"?[\w-_\.]*\"?$/; if(splitted[1].match(regexp_user) == null) return...

Part and Inventory Search

Back
Top