Search results for query: *

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

...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 (user.eventID=mos_events.id) LEFT JOIN mos_users AS...

...may not have teachers, but my added SQL clause doesn't return events if no teachers are associated to it. Old one: SELECT DISTINCT mos_events.* FROM mos_categories AS b, mos_events LEFT JOIN mos_events_users AS user ON (user.eventID=mos_events.id) WHERE mos_events.catid = b.id AND b.access...

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.

Sorry. It's mySQL.

...Any idea on why a field that I KNOW is populated in the backend isn't returning anything in the query? SELECT product.product_id, schedule.*, DAYOFWEEK(schedule.start) AS day, location.name AS locationName, location.city, location.state, location.regDisabled, location.regFile...

Can anyone provide a possible explaination for why I'm getting this error using CFOBJECT in 4.5 (not my server, lest I upgrade it). ================================================= COM error 0x800401F3. Invalid class string The error occurred while processing an element with a general...

I'm still not understanding exactly the purpose of the duplicate() function is. What is the difference between doing set a = b as opposed to set a = dupblicate(b)?

I have a structure that I'm populating with data from a query that has two fields. Here is the query data: <cfset application.categories = structnew() /> <cfset application.categories = getAllCategories /> (getAllCategories is the name of the query resultset) getAllCategories returns: query...