Recent content by mts176

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

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

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...

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

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...

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...

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...

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

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...

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...

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...

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.

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')...

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

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