No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I'm trying to join two tables and group the results. The tables are joined on an EventID field. The basic query gets all upcoming events for the following month: [CODE]SELECT StartDate, EndDate, StartTime, PresentedBy, EventDescription, AdditionalInfo, VendorEventID, FeaturedText FROM EventCalendar, Events WHERE EventCalendar.EventID = Events.EventID AND StartDate >= NOW() AND … |
|
I'm not understanding this. I have a .cfm file which is processing a form submission and doing a number of tests on the form. If certain conditions are met, I need to alert the user and get confirmation. At that point in my code, I've put a standard confirm script: … |
|
When using a small Access database, is it better to return the results of a query and search the result, or to try to filter the results in the query? I tried the latter first, like so: [CODE]<cfquery datasource="cpac" name="results"> SELECT Email FROM Subscribers WHERE Email='#FORM.Email#' </cfquery>[/CODE] and am puzzled … |
|
Hi all, I'm learning JavaScript and have run into a problem. Displaying the contents of a cookie with the code [code] alert(document.cookie); [/code] works fine in Firefox 2.0.0.11, but in Safari 3.0.4, it just displays an empty alert box. Any quick answers? Any resources that you can point me to? … |