Search results for query: *

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.

...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') AND right(PIN,4) = 7151) AND EMAIL = 'myuser@user.com'

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.

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

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

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

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

...splitted = email.match("^(.+)@(.+)$"); if(splitted == null) return false; if(splitted[1] != null ) { var regexp_user=/^\"?[\w-_\.]*\"?$/; if(splitted[1].match(regexp_user) == null) return false; } if(splitted[2] != null) { var...