Search results for query: *

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

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

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

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

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

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

For a shopping cart-enable site, what is the best way to store and transfer a user's session data from non-secure to secure? The secure section will contain the form for them to enter their credit card information as well as submit to the 3rd party payment gateway and back again. The secure...

Our phpBB forum was hacked into recently, and while the data itself is uncorrupted in the tables, I cannot get the database connection to work properly now. The templates all come up but only get the general error statement: "Sorry, but this board is currently unavailable. Please try again...

For some reason, the CFIF inside this loop throws me an error when using the evaluate() function, which is wierd. I've done this a million times before; the list being passed is valid (as is the scope) and just outputting #len(evaluate("variables.#variables.ThisFieldName#"))# renders me the...

Any help on why this query is retrieving the same record multiple times would be greatly appreciated: SELECT p.projectID, p.projectTitle, p.isNamePrivate FROM tblProjects p, tblWorkshops w WHERE p.healthName = 'Tuberculosis' OR (p.healthName = 'Respiratory Diseases' AND...

I'm having difficulty appending the results of one query set to another. I'm getting null values but the recordcount is accurate (adding both queries separate versus the new query total). Here's what I did: <cfset qRefineSearch = QueryNew("projectID,projectTitle,isNamePrivate") /> <cfscript>...

I'm trying to use aliases for a query-of-query, and I'm getting a error that I presume tells me I can only perform a q-of-q against the original recordset, and nothing more. Here's my code: <cfquery name="qSearch" dbtype="query"> SELECT s.*, l.locationName FROM qInitialSearch s, tblLocations...

I have a query that sorts results with various fields being used in the ORDER BY clause, and the last one of four is the date field. However, the dates are being stored in varchar fields (SQL Server), and I fear that CF is not outputting the dates properly since it's sorting by checking the...

I'm trying to filter output from a keyword search based on a number of parameters, and the most important is if a user enters a name that matches one in the record returned with a 'privacy' flag, to not show that record. My problem is I can't figure out how to create a ReFind() inside an IF to...

How can I return the value of a UDF, not as a literal variable's value, but as a placeholder? Example: <cfscript> function isUDF(var1) errorMsg = ""; { // do conditionl testing for first variable entered if var1 != 'foo' (errorMsg = "Custom error 1") else if var1 == 'foo'...

Is there some particular SQL syntax I can enter to have a specific table's field properties display in a browser (from a MS SQL 2000 database)? One example is to view the size, field name and any other attributes of field 'fFoobar' in table 'tWhatever'.

Is there some particular SQL syntax I can enter to have a specific table's field properties display in a browser (preferrably in Cold Fusion)? One example is to view the size, field name and any other attributes of field 'fFoobar' in table 'tWhatever'.

I have to create a query that compares dates. For example, (date1 (plus n months)) has to be greater than date2, where n is an integer. How can I do this in ColdFusion? Some variation of the to_date(var) function, or something more involved?