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

  • Users: deepatpaul
  • Order by date
  1. deepatpaul

    ASP and DLLs

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

    ASP and 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...
  3. deepatpaul

    Resultset cutting off first record

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

    Resultset cutting off first record

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

    Query not returning expected records

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

    Query not returning expected records

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

    Subtracting dates in WHERE clause

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

    Appending an array to an existing nested array

    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"]=>...
  9. deepatpaul

    Subtracting dates in WHERE clause

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

    Subtracting dates in WHERE clause

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

    Subtracting dates in WHERE clause

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

    Query output not being passed

    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).
  13. deepatpaul

    Query output not being passed

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

    Query output not being passed

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

    Query output not being passed

    I get null output to the browser.
  16. deepatpaul

    Query output not being passed

    Sorry. It's mySQL.
  17. deepatpaul

    Query output not being passed

    I have a Location component that has a paypal optional payment field populated, and a Disable webshop registration = yes in the Administration. A query on the front end pulls both of these fields, but is returing the paypal field blank. Below is a sample of the query. location.regDisabled is...
  18. deepatpaul

    CFOBJECT error in cf4.5

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

    Outputting a structure-of-a-structure

    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)?
  20. deepatpaul

    Outputting a structure-of-a-structure

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

Part and Inventory Search

Back
Top