Recent content by deepatpaul

I'm mildly familiar with using ADO and FSO. They both call DLLs?

I have a project coming up that will (eventually) require my ASP (3.0) scripts to make calls to custom DLLs. For the time being we need to create the necessary "hooks" so in the future the DLLs can just read these hooks and get the necessary data with little stress. My questions: 1. What...

*slaps forehead* Thank you so much! I would never have realized that (as simple and obvious as it is now).

I have a basic query that returns x rows. However, when I loop through the result, the first record is always ignored from the resultset. Eh? This is what I am doing to call the database and loop through the results. $report = mysql_query("Select this FROM that", $link); $cnt =...

UPDATE I'm getting the proper return of values here, but if any event has more than 1 teacher associated, it displays it multiple times (n teachers = n displays). SELECT DISTINCT mos_events.*, teacher.name FROM mos_categories AS b, mos_events LEFT JOIN mos_events_users AS user ON...

This query was returning all events based on the following parameters. An additional condition was required, and that was to retrieve all teachers based on the event. Now, some events may not have teachers, but my added SQL clause doesn't return events if no teachers are associated to it. Old...

Er, sorry. That's what I meant. I need mySQL 4.1, but only have 4.0.24 installed.

I have an array with n nested arrays in it. Example: // Array's name is $detevent, with 2 nested arrays; array(2) { [0]=> object(stdClass)(3) { ["id"]=> string(1) "4" ["sid"]=> string(1) "0" ["catid"]=> string(2) "67" } [1]=> object(stdClass)(3) { ["id"]=>...

My version of PHP doesn't have date_sub (or _add) built in yet, unfortunately. Thanks for the effort.

Here is the query (some fields retrieved multiple times for date comparison purposes) SELECT TIME_FORMAT(events.publish_up, '%l:%i %p') as starttime, DATE_FORMAT(events.publish_up, '%M %D') as startdate, DATE_FORMAT(events.publish_up, '%Y') as startyear, DATE_FORMAT(events.publish_up, '%m-%d')...

I'm having trouble coming up with a WHERE condition for a query that returns all events based on user. I only want dates to appear that are less than 30 days minus the current date. I'm running mySQL 4.0.24.

I had 46 records retrieved, only about 1/3 of which were non-null. But, they were all the same value (since we're not using a DISTINCT in here).

Here's the full script: SELECT product.product_id, schedule.*, DAYOFWEEK(schedule.start) AS day, location.name AS locationName, location.city, location.state, location.regDisabled, location.regFile, location.paypalAddress, location.emailRegistration, class.name, class.beginAge, class.endAge...

Are you saying that the nested join treats boolean output differently than varchar?

I get null output to the browser.