Re: JQuery .ajax() call posts back to invoking page only on Production

>For these sorts of this, I usually will turn on the Developer Tools panel >in Chrome and watch the back/forth communication int he browser via the >"network" tab. you can then click on any request's headers, response, etc. > >-Cameron > Hi Cameron, I tried that based on your suggestion and didn'

JQuery .ajax() call posts back to invoking page only on Production

Hello, thank you for any assistance with this puzzler. On my local Windows Vista development machine, I'm using CF 9. Here I have a JavaScript call JQuery's $.ajax() method to write some text to a database using a web service in a CFC. On my machine, it works as expected: writes the values,

Strange form field behavior based on its name

Are out_start and out_end reserved keywords for form fields? I looked for documentation found no references. When I output their value after submission, they're get translated to {t '00:00:00'}. If name them out_xstart and out_xend, the proper date values show. Just an oddity to share. ~~

Re: Empty error message in a query of queries

Thanks for the replies Carl and Brad. Turns out you're both on the right track. The query is the same as it loops over various databases and appends the results using the QofQ. There is no chance of the records being the same since they are in different databases and one of the columns is the

Empty error message in a query of queries

Here's the beginning of the error message for a query of queries: Message [empty string] StackTrace java.lang.ClassCastException at coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156) at coldfusion.sql.imq.TableSo

Re: Programmatically deleting a datasource

Thanks, John, this is a much more concise, readable (and apparently reliable) way to go. In a matter of a few minutes, I was able to properly delete a datasource. Then it was straight-forward to creating way this way too. Again thanks, Brent >Brent, > >Use the AdminAPI instead of accessing t

Programmatically deleting a datasource

I found some terrific code to access the admin api on House of Fusion here. Thanks to all! In experimenting with the methods, I can successfully create a SQL datasource. What I'm having trouble doing is deleting it. factory.datasourceservice.removeDatasource(theDatasourceName) seems the logi

Re: Nestd loop bug with a twist

Adrian, My sincerest thanks! I knew there had to be a way to reference a query like an array. I was trying to use the number of column... Your way is precise, easy-to-read and runs quickly. Thank you for your help! ~| Upgra

Re: Help with query please.

Doug, Rick Root posted a thread which reminded me of the issue you are having. He's talking about a way to optimize a zip-lookup function perhaps similar to yours. That post is at: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50216 Hope this is of some help. Seems to me t

Nestd loop bug with a twist

Hello Forum, I am aware of the bug in regards to an inner loop not being able to access the values in an outer one. It most cases I'd drop a temporary variable right before the inner loop begins so I can reference it inside. What I'm doing now is creating a report from a configuration table th

Re: A query errors referring to deleted columns yet it doesn't refer to them

Yep, it's the right datasource. I'll just use the workaround of having the fields there and not use them. I just hope this issue isn't the tip of some greater iceburg. >Did you double check your data source? Perhaps you are calling an >outdated database?? > >Other than that, I am out of sugges

Re: A query errors referring to deleted columns yet it doesn't refer to them

Thanks, Ben, I forgot to mention I tried that prior. I tried it one more time just to be sure: no luck. I do have the "Max Pooled Statements" set to 0 from the default of 1000 because of issues caching the "*" statements throughout the app. That 0 helped those work. No luck on these hidden

A query errors referring to deleted columns yet it doesn't refer to them

Hello All, I'm wondering if anyone else has bumped into this oddity. I had a table with 25 columns that I had an update query update most of the fields. I then took out those fields from the query, and then the database. Happens all the time, right? For some reason, whenever I run the query,

Re: Duplicate query execution in application.cfm for a certain page

Somehow this one worked itself out. I made the following changes: 1. made some changes to the frame that referred to it, 2. renamed the file and renamed it back, (didn't seem to work) 3. created a new page with a new name and linked to it in the calling frame, 4. removed the link and page create

Re: Duplicate query execution in application.cfm for a certain page

These are good thoughts, Ben. I forgot to mention how simple this page is. I'm accessing it via a simple link in a navigation frame. Come to think of it, that is one thing I didn't think of. The refering page has no form, isn't doing a post and has no validation JavaScript. It's a basic "a

Duplicate query execution in application.cfm for a certain page

Hello all, I'm having trouble debugging this one. I have a query in application.cfm that inserts to a table. For most pages, I see one record. For a particular page, I am seeing two. What would be in this file that could cause application.cfm to fire twice? I even tried using a request-sco

Re: select * (star) caching

If that is related to the "Max Pooled Statements" field in a CF ODBC configuration, that makes sense. By setting this value to zero, I was able to resolve this issue. Thanks for your contributions. ~| Introducing the Fusion Au

Re: select * (star) caching

And thanks to everyone else who posted their ideas. I appreciate your insights and willingness to help! And to HoF for existing. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFus

Re: select * (star) caching

ANSWER FOUND By updating the datasource's "Max Connection Pooling" property to 0, each change to the db is reflected dynamically on the next front-end page refresh. This is exactly how I expected "select *" to work... find the columns real time and gimme 'em all. Thank you Brian Rinaldi for yo

Re: select * (star) caching

Brian, setting "Max Pooled Statements" to 0 worked the first time I ran the query, but not any times after that. How crazy. I even tried setting the "Timeout" and "Interval" to 0s and no luck at all. I also have "Maintain Connections" unchecked. >I believe this can be accomplished by setting

Re: select * (star) caching

>Somehow this thread seems to have gotten split. Yes, I goofed when I created the post because I wasn't subscribed. Previously it would not have added to HoF. Now it does subscribe a non-subscriber automatically and it refreshing the Talk page, my post wasn't there. No sooner than I post a s

Re: select * (star) caching

Has anyone out there had any experience with the Microsoft JDBC Type IV driver? When I delete a column referenced in a .* query, I get a "value cannot be converted to the requested datatype" error from the default JDBC driver.

Re: select * (star) caching

Here's an example query. select *, 'x' as a_test from sc where sid = So, yes, cfqueryparams in the where clause. What was your solution? Seems quite relevant to the situation at hand. Thanks for your input. ~~

Re: select * (star) caching

Right, another guy here suggested the same thing. That would essentially bypass the way CF is mapping out the "*" translation and allow SQL a chance to built the field list. The query would be copied-and-pasted into a SQL stored procedure so that's easy. The truth of it told, there are 524 st

Re: select * (star) caching

Russ, I tried unchecking the "Maintain Connection" checkbox from CF Admin for this datasource and no luck. I even set the max cached queries to 0. I had high hopes because it makes sense that something with a CF optimization algorithm is over-caching. Any other ideas? These are good ones...

Re: select * (star) caching

Thanks, Andrew, Nope, not using cachewithin or cachedafter in any of the queries (unless that's something that is hidden in there by default). I am using v7.0.1 at this moment. I'm going to upgrade to 7.0.2 soon. Is this an issue with 7.0.1? I have set the Maximum number of cached queries to

Re: select * (star) caching

Thanks for this, Russ! I will test this tomorrow. The checkbox may save a lot of short-term work. My thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by

Re: select * (star) cache

Thanks for the comment, Brian. If changing the code recomplies the query, there must be a way to recompile all the queries by marking them for replacement as changing its code does. I'd like to be able to drop all queries from cache with a URL parameter or hidden form field or something I can

Re: select * (star) caching

I don't mind doing so. It would a) save me the headache of going through each query and de-starring it, and b) provide a user-controlled vehicle for flushing this cache so I know when it's going to happen. The initial cost is going to save me tons of mindless coding and testing. ~

Re: select * (star) caching

Teddy, I was hoping that'd be the answer, but it's not. Doesn't seem to affect anything relevant to the queries. There must be something because if I add a column to the table with a star, I got an error "value cannot be converted to the requested type". I changed the query to add a static va

Re: select * (star) caching

Thank you, Teddy, I will try it out. Thanks for your help and sparing me "best practices" preaching. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers

Re: select * (star) cache

Thanks, Rick. My experience thus far has been a different error message each time I change the database table. I've never seen anything like it. If I change the cfc query which uses * to anything else and refresh, I get good data. Then I can change the same query back to what it was with the

select * (star) cache

Is this new to CF 7? I've got a handful of "select *" queries that when I modify the underlying table, the results do not include the new column(s). If this is a known issue, how can I refresh the cache for CF to pull the new fields? Since I inherited the app, listing all the columns and idea

select * (star) caching

Is this new to CF 7? I've got a handful of "select *" queries that when I modify the underlying table, the results do not include the new column(s). If this is a known issue, how can I refresh the cache for CF to pull the new fields? Since I inherited the app, listing all the columns and idea

Re: Select * in a view needs "recompiled"

Thanks for the insights, John. Glad to have my observation on SQL's handling of the * confirmed. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, de

Re: Select * in a view needs "recompiled"

I was just thinking that there might be a setting in SQL Server that was geared for optimization and cached the view definition. Perhaps there is a way to reconfigure it to check for changes more often. I might not change it because it's a small extra step to re-save each view (there aren't ma

Select * in a view needs "recompiled"

Using MS SQL Server, I have a view that pulls a table with a "*". I added a column to that table, and the view's data did not reflect the new column right away. In Query Analyzer, if I ran the view after adding the column from right-click "Open View", the new column wasn't there. If I went in

Re: Path of a cfc important?

Russ and James, Thanks for your help. You were both right on. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a

Path of a cfc important?

Hello all, I have a bunch of .cfcs in the same folder whose init() function creates application-level instances of the cfc object. I make reference to one of these objects as a parameter when initializing another cfc. It works fine when everything is in the same folder. When I pass in an app