I have a form/action page set that allows users to create a record for past work weeks. The premise is simple. If they are the first one to create a work week record, fine it is created and then a CFLOCATION tag takes them to a Task page where they can add the tasks they hace completed. It...
I'm working with a MySQL table via MySQL Front. I'm entering dates in a DATE field using the format provided (YYYY-MM-DD) and I click tab (or enter, I've tried both); the SQL pane shows that the record has been set. When I click the sort column, the dates that I have manually entered disappear...
I have two related tables that I want to update via forms on two CF pages. The first page asks the user to select a 'week number' from a drop list. Once the week number is chosen, the user clicks 'Submit' and CF runs an action page that updates the week table and and MySQL autoincrements an ID...
I'm sure I'm missing something simple here, but I can't see it. I'm running a simple query that kicks grouped categories out to an RTF file. I have the RTF header brought in via a SSinclude, and the query grouped by category.
Here's my page:
<CFQUERY DATASOURCE="manage" name="GetReports">...
I have a fairly straight-forward set of MySQL tabes and we're using CF5. We putting together a weekly reporting tool that needs comments from project leads. Most of what we're doing from week-to-week tends to be duplicative, but with minor updates. Because much of what's in the text remains...
I was halfway there, but now back to square one. I have two XP PCs ... one XP Pro (DELL) and the other XP Media Edition (SONY). They are connected via a Linksys wireless router/hub (I'm only using the hub right now). Both the computers are operating with different computer names, but under...
Soliciting a little advice here ...
We're setting up a click-through app where our users will name a record and then click through and select multiple categories per record to create the characteristics of that record.
For example, in the first page ('Category') the user would select one or...
I'm trying to run a simple new record insert with the code below, but I keep getting a syntax error. I've looked it over, and I'm sure there's something obvious that I'm missing here, but I can't see it. I have already checked and all the columns exist, and they are all the right data types...
I'm running CF5 on an XP box with IIS 5.1. After installing CF5 server the initial after-installation page loads fine. But the validate link brings up a HTTP 500 Internal server error page in the browsers with the message: "Page cannot be displayed."
I thought maybe the CF server...
Hello all,
Dumb question here, but I thought I would ask. I just picked up a Sony Vaio RZ46G desktop unit, which comes with XP Media Edition installed. I would like to install XP Pro overtop because there are functions in XPP that I need. I'm wondering if any of the cool media functionality...
I'm working on a dot-mil server and, much to my chagrin, I've learned that some of our users' IM departments refuse to allow the installation of the Flash plugin on their browsers (an unexplained security rule).
I've incorporated some Flash into the site, and for those who can get to it, I'd...
I'm running into a frustrating DWMX template error that I can't quite figure out. I have set up a template and I want to place a call to a ColdFusion <cfinclude> in the template's editable region.
When I go to rewrite the include (in this case simply changing "<cfinclude...
I have a several different search/results page that contain multiple lists with dynamic URL links to different related detail pages. When the user gets to one of the detail pages, I want to provide a customized URL to return them to the list page where they started.
I have a general idea about...
Hello all ... be gentle, I'm new at this:
I've got a simple case query. One works (the top one), but when I try to add additional columns to the query it fails. I reckon it's a pretty simple mistake I'm making, but I don't know what. Any help is appreciated...
The dynamic list form that I've created is working fine, but some of the titles are un-Godly long and are causing layout problems because the list field gets stretched so wide. Is there a way to truncate the values in the list to no more than 50 characters or so (and add a little elipsis on the...
I've set up a script routine where the values are dynamic based on user input (via set field in an unsaved Find Mode). For some reason, the FileMaker "No records match this request." error message is not being suppressed by the If Status(Current Error) statement.
The script works...
I've got a CF page where the form page and the action page are the same page. I'm using a dynamic form list that allows the user to pick from a list of systems. When the user chooses a system from the list, the form displays the system and sends the system ID in a Form variable.
Basically...
I've been working with one of Ben Forta's examples and I'd like to modify it. In it's current form, the code (below) uses session variables to remember the last keyword that was queried. The action page and the result page are the same in this instance (i.e., the search is done and the user is...
I have two tables and I would like to delete records from one based on associated values in another. For example, using the example tables below, how would I delete all the records in the TIDS table that had an associative value of 'Air Force' in the TID_ADMIN table?
TID_ADMIN...
Hello all,
I'm new at this, so please be gentle. I'm using MySQL with ColdFusion, and need a way to display a list of data from one table when a user selects a particular system. I know I need to use a three-way join to get where I need to go, but I'm getting lost along the way. Here's my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.