Recent content by RikForgo

Well, there was some progress. It's actually sending me back to the form page, but the ID still doesn't go with it. FWIW, I added the qGetitBack query after the cfelse. It moves me along to the form page, but it can't find the ID. The form page code is below, followed by the error message if...

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

Yep, I was entering the date format wrong, for example I was submitting 2004-29-03 when it should have been 2004-03-29. v2.5 simply wouln't take it, but v3.0 showed an error message that said it was entered incorrectly. Geez. Thanks for the help.

V. 2.5 on XP.

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

That did it. Thanks guys!

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

Hmmm. Ok, that's just a query on last week's remarks to an edit field and a simple INSERT, correct?

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

> are you going to tie an item to both a category and a > subcategory? No, items will be tied just to a subcategory. > to more than one of each? No, just the one subcategory (if that's what you mean). > to a subcategory but not to the subcategory's parent > category? No, the category...

Sorry, I stupidly rushed through some bogus examples because I'm somewhat restricted in what I can post. These aren't the actual items that would be checked, but I wanted to know if the structure made sense. Perhaps it doesn't. I didn't cut my teeth on data modeling so bear with me. In our...

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

Yep, changing the field name from "date" to "pub_date" fixed the problem. Thanks for the catch.