Re: Alternatives to Microsoft SQL Server 2008 Management Studio Express

2011-10-25 Thread Carl Von Stetten
You can also purchase SQL Server 2008 Developer Edition for generally less than $50, and it comes with the full SQL Server Management Studio. Here's a link on Amazon.com: http://amzn.to/uqvTpU Carl On 10/25/2011 1:42 PM, Russ Michaels wrote: The express edition has quite a few limitations,

Re: Displaying and storing 3-state boolean values

2011-10-21 Thread Carl Von Stetten
Thanks John and Gerald for the ideas. I'll keep plugging away... Carl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Displaying and storing 3-state boolean values

2011-10-20 Thread Carl Von Stetten
I'm rewriting a CF application that stores its data in SQL Server (2005, moving to 2008R2 soon). I have a number of bit datatype columns in my tables, which correspond to true/false or yes/no values in the application. For some of these values, I need to track if they have not yet been set

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
Is it possible that you set IE9 on your computer to use Compatibility View to simulate IE7 for that website? On 10/19/2011 11:05 AM, Robert Harrison wrote: I have an issue where user agent (cgi.HTTP_USER_AGENT) for IE 9 is being reported correctly on one server and incorrectly on another...

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
In fact, I just tested that very think on my machine and it did report back as IE7 instead of IE9. Carl On 10/19/2011 11:14 AM, Carl Von Stetten wrote: Is it possible that you set IE9 on your computer to use Compatibility View to simulate IE7 for that website? On 10/19/2011 11:05 AM, Robert

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
Sorry, thing instead of think. I'm typing with one arm in a sling.. :-[ . Carl On 10/19/2011 11:15 AM, Carl Von Stetten wrote: In fact, I just tested that very think on my machine and it did report back as IE7 instead of IE9. Carl On 10/19/2011 11:14 AM, Carl Von Stetten wrote

Re: cgi.HTTP_USER_AGENT

2011-10-19 Thread Carl Von Stetten
Robert, I hate to add another response to the thread, but did you check whether you inadvertently enabled Compatibility View in IE9 when viewing the site that is reporting incorrectly? I was able to reproduce your results when this was turned on. Carl On 10/19/2011 11:24 AM, Robert

Re: Session Variables

2011-10-18 Thread Carl Von Stetten
Rick, What is your applicationtimeout set to? If it's set to 20 minutes, it will clear your session cache as well (I think). Also, check your application and session timeout settings in CF Admin. HTH, Carl On 10/18/2011 10:32 AM, Rick T wrote: cfapplication name=newapp

Re: Coldfusion as Windows Service Throwing 500 Errors

2011-10-12 Thread Carl Von Stetten
Good point. I just reviewed the ColdFusion 9 Server Lockdown Guide and made all of the folder permissions adjustments to allow the domain account to work without being an administrator. Everything is now working perfectly. Thanks again for the advice. Carl On 10/11/2011 9:07 PM, Dave Watts

Coldfusion as Windows Service Throwing 500 Errors

2011-10-11 Thread Carl Von Stetten
My backup ColdFusion Standard server, which runs on 32-bit Windows 2003, just started throwing 500 errors with the following stacktrace displayed: java.lang.NullPointerException at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:285) at

Re: Coldfusion as Windows Service Throwing 500 Errors

2011-10-11 Thread Carl Von Stetten
Yeah, I forgot to state that it was configured using a domain account for ColdFusion servers, that is supposed to be in the local Administrators group on the machine. I just checked into the server's local Administrators group and discovered that this domain account is not in that group

Re: JVM Heap Size

2011-10-06 Thread Carl Von Stetten
Did you install the regular Java JVM or the JDK? You'll need the JDK. HTH, Carl On 10/5/2011 8:36 AM, John M Bliss wrote: Are you experiencing any problems with the current behaviour? We're just tuning stuff to get the fastest possible responses from our app. Related: I just tried to

Re: SQL grrr

2011-09-26 Thread Carl Von Stetten
Richard, I think this will work (untested, assumes SQL Server): select t.ID from mytable t inner join mytable a on t.id = a.id and a.value = 'A' inner join mytable b on t.id = b.id and b.value = 'B' inner join mytable c on t.id = c.id and c.value = 'C' HTH, Carl

Re: SQL grrr

2011-09-26 Thread Carl Von Stetten
, 2011 at 10:41 AM, Carl Von Stetten vonner.li...@vonner.netwrote: Richard, I think this will work (untested, assumes SQL Server): select t.ID from mytable t inner join mytable a on t.id = a.id and a.value = 'A' inner join mytable b on t.id = b.id and b.value = 'B' inner join mytable c

Re: CF8 Instances hanging every 3-4 days or so.

2011-09-23 Thread Carl Von Stetten
I have a problem with a non-CF-related out-of-control service on one of my servers. I purchased a product called ProcessLasso (cost about $150 IIRC). It allows you to assign thresholds for CPU utilization that will automatically kill rogue processes or restart them. Might be worth

Re: CF8 Instances hanging every 3-4 days or so.

2011-09-23 Thread Carl Von Stetten
Russ, I didn't know that. Nice! Carl On 9/23/2011 5:11 PM, Russ Michaels wrote: in case ur using windows 2008 server, you have this functionality built right in :-) On Sat, Sep 24, 2011 at 1:08 AM, Carl Von Stetten vonner.li...@vonner.net wrote: I have a problem with a non-CF-related

Re: CFBuilder 2 Virtual Hosts

2011-09-16 Thread Carl Von Stetten
and Firefox tabs, and when I press CTRL-ALT-E to open in external browser (configured for Chrome), it loads the page in Chrome just fine. So, I guess this is another case of RTFM!! Lesson learned. Thanks again, Carl On 9/14/2011 1:08 PM, Carl Von Stetten wrote: I'm a complete CFBuilder n00b (just

CFBuilder 2 Virtual Hosts

2011-09-14 Thread Carl Von Stetten
I'm a complete CFBuilder n00b (just installed this morning for first time). I've been developing for years using Dreamweaver, so this is going to be a huge change for me. OK, now to the problem. I develop on a 64-bit Windows 7 PC. I have IIS 7.5 running local versions of the intranet

Re: CFBuilder 2 Virtual Hosts

2011-09-14 Thread Carl Von Stetten
I guess I'm confused about the difference between wwwroot and project root. Do people in this type of environment do their code editing in the same place as IIS serves the site from? On 9/14/2011 1:36 PM, Andrew Scott wrote: If wwwroot is not your project root, CFbuilder needs a mapping.

Re: CFBuilder 2 Virtual Hosts

2011-09-14 Thread Carl Von Stetten
Would you mind sharing some screenshots of how you configured your local server, and how you configured the project? Do you have multiple applications set up as distinct projects in your CFB setup? On 9/14/2011 2:01 PM, Justin Scott wrote: I guess I'm confused about the difference between

Re: CFBuilder 2 Virtual Hosts

2011-09-14 Thread Carl Von Stetten
Justin, Are you using CF 9 Developer Edition on you local machine? If so, do you have it installed as a standalone (single instance) install, or a multi-server (J2EE) install? If standalone, what does your Document Root point to on the ColdFusion Server Setup screen for Local Server

Re: CFBuilder 2 Virtual Hosts

2011-09-14 Thread Carl Von Stetten
What I've done is start a new project in CFBuilder, and pointed the project to the folder one step above the IIS site's webroot (which is C:\WebApps\App1\wwwroot), so the project folder would be C:\WebApps\App1. Do I need to set the CFBuilder server's document root to be pointing at

Re: loop timing out

2011-06-29 Thread Carl Von Stetten
The problem with mapped drives is that they may not be available or set under the user account the Coldfusion service is using. I'm assuming your running on a Windows box. Drive mappings are created at the time a user logs onto a Windows box. Since Coldfusion runs as a service, the user

Re: loop timing out

2011-06-29 Thread Carl Von Stetten
I guess what I was trying to say is that depending on how drives are mapped, unless the user physically logs in to the desktop, drive mappings may not get applied (specifically drives mapped through login scripts). Login scripts don't appear to get processed when a service logs in. I wasn't

Re: Handling Multiple Requests

2011-06-28 Thread Carl Von Stetten
A few options: 1. Disable the link after the first click. 2. Show a spinner graphic to provide feedback to the user that something is happening, perhaps with a caption that says Processing request... These can be done client-side with javascript (jQuery makes it a bit easier

Re: Handling Multiple Requests

2011-06-28 Thread Carl Von Stetten
Can't think of a way to globally disable multiple clicks. Do you use jQuery on your site at all? Do you use Application.cfc or Application.cfm? If Application.cfc, adding the link disabler or status dialog could be done by modifying your onRequest() method to insert some script tags into

Re: Handling Multiple Requests

2011-06-28 Thread Carl Von Stetten
Not off the top of my head. Do you assign any special CSS classes to the links for your lightbox app? If so, your multi-click disabler could filter those out with jQuery selectors. By the way, I agree wholeheartedly with Alan's comment about addressing the slow page loads. I'd use my

Re: SQL Query Problem

2011-06-21 Thread Carl Von Stetten
How about: select b.* from b left outer join a on b.id = a.id where a.id is null Carl On 6/21/2011 10:37 AM, Jenny Gavin-Wear wrote: Two tables each containing a shared primary key ID. I am trying to create a query that lists records from table B that are not in table A. Many thanks,

Iterative Business Objects

2011-06-15 Thread Carl Von Stetten
I'm playing around with developing some CFCs for an intranet application. I have some objects which have queries with multiple records associated with them. Rather than store an array of objects to work with the queries, I was exploring the Iterative Business Objects (IBOs) model. I looked

Re: Iterative Business Objects

2011-06-15 Thread Carl Von Stetten
it as the basis for something of your own... If you don't need persistence, it should be easy to convert the array-of-struct handling code into query handling code. Sean On Wed, Jun 15, 2011 at 11:11 AM, Carl Von Stetten vonner.li...@vonner.net wrote: I'm playing around with developing

Re: CFQuery Select and single quotes in string

2011-06-10 Thread Carl Von Stetten
What DBMS are you using? MSSQL, MYSQL, Access (bleeackk!), other? MSSQL uses single quotes in the WHERE clause. However, if you use cfqueryparam for all of your where clause pieces, single quotes in your strings should pass through in the database request just fine. What is the data type of

Re: How to do this with CF and JS?

2011-06-08 Thread Carl Von Stetten
Are you trying to queue the sound tracks up to play one after the other? On 6/8/2011 10:25 AM, Rick Faircloth wrote: To be clearer, everything works fine, except for the fact that nothing loops. I get the first sound track, soundTrack01.mp3, played once, and then everything stops.

Re: How to do this with CF and JS?

2011-06-08 Thread Carl Von Stetten
play.sound command line) outside the DOM, then reinsert it. Make sense? -Original Message- From: Carl Von Stetten [mailto:vonner.li...@vonner.net] Sent: Wednesday, June 08, 2011 2:41 PM To: cf-talk Subject: Re: How to do this with CF and JS? Are you trying to queue the sound

Awful quiet today...did I forget a holiday?

2011-06-03 Thread Carl Von Stetten
Just checking, since I've seen no messages today... =-O ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

ORM and Sites with Multiple Databases

2011-06-02 Thread Carl Von Stetten
I am thinking about refactoring a few applications of mine to use ORM. One problem that I think I will have is that the applications talk to multiple databases (in the vast majority of cases, the application only reads data, it does not write data). It's a data integration application that

Re: ORM and Sites with Multiple Databases

2011-06-02 Thread Carl Von Stetten
:45 PM, Carl Von Stetten vonner.li...@vonner.net wrote: I am thinking about refactoring a few applications of mine to use ORM. One problem that I think I will have is that the applications talk to multiple databases (in the vast majority of cases, the application only reads data, it does

Re: ORM and Sites with Multiple Databases

2011-06-02 Thread Carl Von Stetten
Nevermind... http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSbfbbf049491c37b01e63e3d129fe0a8552-8000.html Carl On 6/2/2011 12:21 PM, Carl Von Stetten wrote: Kewl!! Didn't know that? I'll have to dig into the docs. Do you happen to have a link to the docs where it talks about

Re: HOF Site

2011-05-20 Thread Carl Von Stetten
What are you seeing? It looks OK to me. Carl On 5/20/2011 8:20 AM, Steve Milburn wrote: Just an alert to those who maintain the HOF site (Michael?) - It looks like it's been hacked. Anyone else seeing something unexpected when view the main page? I can navigate to directly to some other

Re: ColdFusion and AJAX choices

2011-05-17 Thread Carl Von Stetten
jquery +1 On 5/17/2011 8:50 AM, Darius Florczyk wrote: Hi, I need to add AJAX functionality in a new project and wondering if anyone had any recommendations for the most robust, stable choice. I will be using it with CF7 but need for it to be easily portable to Railo. The need is to

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-11 Thread Carl Von Stetten
lol. ;-) On 5/10/2011 8:26 PM, Dave Watts wrote: You could always both swap to a real database: http://www.oracle.com/technetwork/database/express-edition/overview/index.html Your DB2 link is broken. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-11 Thread Carl Von Stetten
While installing the trial of SQL Server 2008 will get you the full Management Studio and Business Development Studio (or whatever it is called in 2008, and is required for developing SSIS solutions), SQL Server Express does not have the SSIS service. You have to have at least one full SQL

Re: Solr Errors

2011-04-11 Thread Carl Von Stetten
Mary, What are you loading into your index (queries or documents)? Can you provide a code snippet of your process? Carl On 4/8/2011 9:36 AM, Mary Jo Sminkey wrote: Well, by doing some research on the Solr boards and lists, I was able to figure out the problem. It appears to be due to CF

Re: Storing Arrays or Structures in a database

2011-04-06 Thread Carl Von Stetten
Keep in mind that WDDX adds quite a bit of extra stuff around your data as compared to JSON. For example, take this ColdFusion array: cfset myArray = [John,Paul,George,Ringo] Here is the serialized JSON version: [John,Paul,George,Ringo] Here is the WDDX version: wddxPacket

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Carl Von Stetten
I'm trying to wrap my head around this, so please excuse me for jumping in. If I understand this correctly, the query result is an object placed in memory when execution is complete, and variables.qry is merely a pointer to that object. When the cfset session.myQry = variables.qry is

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Carl Von Stetten
Wow, I finally got it!!! :-) Thanks, Carl On 3/24/2011 1:27 PM, Brian Kotek wrote: That's correct. On Thu, Mar 24, 2011 at 4:18 PM, Carl Von Stetten vonner.li...@vonner.netwrote: I'm trying to wrap my head around this, so please excuse me for jumping in. If I understand this correctly

Re: Javascript question

2011-03-14 Thread Carl Von Stetten
Is it possible that the click event is actually happening on the TD elements and not the TR? You might try attaching the click event to the parent table (so it only binds to one element) and take advantage of event bubbling. Use the event.target attribute to get to the row:

Re: ColdFusion License and Builder

2011-03-10 Thread Carl Von Stetten
Adobe modified the EULA again for CF9 to allow Standard and Enterprise to installed as Production Software on one server, as Disaster Recovery Software (or as you called it a 'dark' server) on a different single server, and as Development Software for internal development, testing, and

Re: Delete all records works, but can't import data

2011-03-02 Thread Carl Von Stetten
I wouldn't expect that the delete or truncate would still be running, but if they are, wrapping all of the cfquery tags in a cftransaction might help, or wrapping the delete/truncate in a transaction, then calling the insert in a separate cftransaction? HTH, Carl On 3/2/2011 9:57 AM, Mallory

Re: Delete all records works, but can't import data

2011-03-02 Thread Carl Von Stetten
What DBMS are you using? SQL Server, MySQL, Oracle, or MS Access? Carl On 3/2/2011 10:43 AM, Mallory Woods wrote: Carl, I will try that. I had the truncate in a cftrans.. let me try them both and see what I get. Nope.. still the same result. I have tried having both of them in one

Re: Delete all records works, but can't import data

2011-03-02 Thread Carl Von Stetten
I don't have any experience with MySQL, but I've heard that there's a way to enable multiple statements in a single cfquery. Once thats enabled, look at the MySQL docs for the syntax for putting multiple SQL statements together. In SQL Server (which I use frequently), you would do something

Re: Delete all records works, but can't import data

2011-03-02 Thread Carl Von Stetten
First, you need to move the Truncate query outside the loop. Otherwise it is being called on each loop iteration, and erasing any records you inserted on the previous iteration. Second, close your table with a /table tag after the /tr Third, you have a comment about blank rows being invalid,

Re: Delete all records works, but can't import data

2011-03-02 Thread Carl Von Stetten
Glad to here you got it sorted. Good luck! Carl On 3/2/2011 12:43 PM, Mallory Woods wrote: Just to confirm, its working now! :) Its amazing what a fresh set of eyes will do. On Wed, Mar 2, 2011 at 3:36 PM, Mallory Woodsmallory.wo...@gmail.comwrote

Re: Invalid Precision Value from SQL Server CF9

2011-02-18 Thread Carl Von Stetten
CF will read in bit values from SQL Server and evaluate them as equivalent to true/false or yes/no. However, SQL Server expects 0 or 1 from ColdFusion when writing to a bit field. There's probably a UDF on CFLib.org that converts CF boolean values into strict bit values, but here's one I

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread Carl Von Stetten
Looks like you might need to revise the procedure to CAST the calculated value back to Numeric(10,2) before returning it? Carl On 2/16/2011 2:30 PM, James Skemp wrote: Thanks Mike. Opened up the procedure and gave it a look. It looks like there's some multiplication and division going on,

Re: Grid like form with multiple inserts

2011-01-28 Thread Carl Von Stetten
Some more information might be helpful. Can we see the code of the form itself? Also, are you just inserting new records into your database, or editing existing records? On 1/28/2011 10:34 AM, Monique Boea wrote: Any sample code for a grid-like form? On Thu, Jan 27, 2011 at 8:16 PM,

Re: Grid like form with multiple inserts

2011-01-28 Thread Carl Von Stetten
OPTION value=Peer To Peer ConsultationPeer To Peer Consultation/option OPTION value=Gone HomeGone Home/option /CFSELECT /td tdinput name=minutes#userID# value= size=5/td /tr /cfif /cfloop On Fri, Jan 28, 2011 at 1:43 PM, Carl Von Stetten vonner.li...@vonner.netwrote: Some more information

Re: Mailing List program

2011-01-07 Thread Carl Von Stetten
I've used Mozilla Thunderbird for years. Carl On 1/7/2011 12:53 PM, Asim Manzur wrote: Any recommendation for the CF mailing list application? ~| Order the Adobe Coldfusion Anthology now!

Re: Regex Question

2010-12-03 Thread Carl Von Stetten
Robert, How about treating CGI.path_info as a list, using / as your delimiter. Then you can use the various list* functions in CF to parse it however you want. Carl On 12/3/2010 9:26 AM, Robert Harrison wrote: Regex is not my strong suit, but someone may know this off the top of their

Re: (ot) SQL Server Full-Text Search CONTAINS()

2010-11-23 Thread Carl Von Stetten
Matt, I googled on sql server noise words and found this link: http://arcanecode.com/2008/05/29/creating-and-customizing-noise-words-in-sql-server-2005-full-text-search/ I followed the directions and found the noise lookup file being used by SQL Server 2005 on my computer, and confirmed that

Re: What was that security again?

2010-11-18 Thread Carl Von Stetten
I don't think any Server roles are needed, but db_datareader Database role should provide the SELECT permissions. I'm not sure about the permissions for stored procedures. Carl Kinda.. Are there any particular SERVER ROLES or Database Role Membership? Thanks! GRANT SELECT GRANT EXECUTE Is

Re: I think I'm just making this way too hard...

2010-11-05 Thread Carl Von Stetten
Rick, I think you might be able to simplify this further, and take ColdFusion out of the query altogether. Bear in mind I've never used MySQL, but according to the MySQL docs something like this should work: select totalNew from 04a_dailyNumberNewHMLSProperties where

Re: Question about using javascript in .cfm files...

2010-10-28 Thread Carl Von Stetten
Rick, I have shared CF variables with JavaScript too. What I usually do is this: If I have to do any processes to define the CF variables, I put them at the top of the document, above the head section. Then, in the head section of my CFM page, I add a cfoutput inside a script tag and pass

Re: Question about using javascript in .cfm files...

2010-10-28 Thread Carl Von Stetten
Rick, I have shared CF variables with JavaScript too. What I usually do is this: If I have to do any processes to define the CF variables, I put them at the top of the document, above the head section. Then, in the head section of my CFM page, I add a cfoutput inside a script tag and pass

Re: looping through an insert statement

2010-10-26 Thread Carl Von Stetten
Rick, Can you provide a dump of the FORM scope? Thanks, Carl ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1 sdalifsdaifasifsadi equals '#form['ProteinSequence' LoopCount]#', which is called AA_sequence in the data table as shown below Insert into

Re: Memory Upgrade - Revisited

2010-10-21 Thread Carl Von Stetten
Steve, Windows Server 2003 Enterprise and Datacenter editions are the only 32-bit OS's that support more than 4 GB of RAM. However, you'll still be stuck with the limitations of the 32-bit JVM, which is about 1.5-1.8 GB of memory. So you'll still be wasting all the extra RAM. Only a

Re: Sessions persist after server restart.

2010-09-22 Thread Carl Von Stetten
I don't know what the answer is, but it might help if you state which J2EE server you are using (JRUN, JBoss, etc.). Carl No, the J2EE sessions are persisting between server restarts, just like the documentation says. The docs just don't tell how to turn it off. Adobe hints that you can

Re: getting server name

2010-09-02 Thread Carl Von Stetten
Nice one! 8^) Eric, You can do this via a java object. Try this code to get the local server host name: cfset inet = CreateObject(java, java.net.InetAddress) cfset inet = inet.getLocalHost() -- Peter Amiri Founder | Alurium Hosting 949-338-3862 | pe...@alurium.com | http://www.alurium.com

Re: Style sheets with cfcontent

2010-08-26 Thread Carl Von Stetten
I've had the same problem in the past. Instead of using a link to load the stylesheet, try this in the head section of your page: head style cfinclude template=/path-to-your-css/your-css-file.css /style This will embed the external stylesheet into your page. HTH, Carl Hi All - I am

Re: cfqueryparam list attribute

2010-08-11 Thread Carl Von Stetten
Matthew, SQL should have no problem with a null being passed for a list, even with integers (I just tested this against MS SQL Server 2005, although I use BlueDragon JX 7.1 instead of ACF). If you are using the null=#!isDefined('myVar')# attribute in your cfqueryparam, then a SQL NULL should

Re: www.cbo.gov down. CF to blame?

2010-07-28 Thread Carl Von Stetten
Last I heard, they were running New Atlanta's BlueDragon.Net, which allows mixing CFML and ASP.NET code. Carl On 7/28/2010 6:25 AM, Andy Matthews wrote: They at least have cfm pages exposed in the URL, although I've heard that it's just ASP.NET included, or called, by ColdFusion. andy

Re: ordering by lowest price (across two columns)

2010-07-06 Thread Carl Von Stetten
You'll need to put the same IF statement into the order by clause. SQL will only sort on columns that actually exist in the table, not dynamically calculated columns (such as your orderprice alias). SELECT SQL_CALC_FOUND_ROWS P.normalprice, P.saleprice, IF(P.saleprice P.normalprice,

Re: SQL Gurus... can this query be written more efficiently?

2010-06-17 Thread Carl Von Stetten
Che, How about this: select searchterm, searchtype, numresults, timestamp fromusersearch where searchtype = cfqueryparam value=#arguments.searchtype# cfsqltype=cf_sql_smallint and numresults cfqueryparam value=0 cfsqltype=cf_sql_smallint cfloop index=i

Re: coldfusion and dynamic query columns

2010-06-08 Thread Carl Von Stetten
Try changing your loop to: cfloop list=#variables.vMarks# index=index td#index#/td /cfloop HTH, Carl ~| Order the Adobe Coldfusion Anthology now!

Re: coldfusion and dynamic query columns

2010-06-08 Thread Carl Von Stetten
Wow, I botched that big time!!! Try this instead: cfloop list=#variables.vMarks# index=index tdquerymarks[index]/td /cfloop Carl Try changing your loop to: cfloop list=#variables.vMarks# index=index td#index#/td /cfloop HTH, Carl

Re: Data Parse error

2010-03-18 Thread Carl Von Stetten
Steven, Try simplifying your insert query to troubleshoot the problem. Remove all but the first field from the query and test. Add one more field and test, rinse and repeat. Also, enable debugging in CF Administrator, and make sure that you add your computers IP address to the debug list.

Re: IE Cflogin

2009-05-14 Thread Carl Von Stetten
It looks like IE is doing something strange, like storing login fields. Which version of IE is involved? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/15 Brian Bradley bbrad...@plrb.org: I have Use J2EE Session Variables checked, as well as

Re: IE Cflogin

2009-05-14 Thread Carl Von Stetten
Oops, hit the enter key accidentally... Brian, Can you turn on Debugging and have it show all of the variables scopes? This might help you figure out where the session id is coming from. Pay particular attention to the cookie scope. Also, check your Application.cfm/cfc for

Re: SOT: Serving GIS data on the cheap.

2009-01-20 Thread Carl Von Stetten
Ian, You might look into MapGuide Open Source http://mapguide.osgeo.org Carl Anybody out there work with serving GIS data on a website. We have our own, custom GIS data and we would like to serve it on our website. I have looked an using the Google Map API and it can serve up custom

Microsoft SQL Server JDBC Driver and Authentication

2008-12-04 Thread Carl Von Stetten
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service

Re: Microsoft SQL Server JDBC Driver and Authentication

2008-12-04 Thread Carl Von Stetten
I tested a little bit further by going into SQL Server Management Studio and removing permissions to the database for the ColdFusion service login account. When I attempt to run the query, it does attempt to use the username I'm passing, but then gives me an error: Cannot open database GDI

Re: Microsoft SQL Server JDBC Driver and Authentication

2008-12-04 Thread Carl Von Stetten
Ooops. I missed a critical part of your message. You said you did get Windows Authentication to work, but you want to specify individual credentials, per query. Sorry for the confusion. However, one thing you may try is create a domain group, then grant database access to that group. In that

Re: Empty error message in a query of queries

2008-09-17 Thread Carl Von Stetten
Brent, Without seeing the two queries that your are joining together, I can only guess at the problem. Likely, one of the columns in qReportSummary doesn't match the datatype of the corresponding column in qSummary, or you don't have the same number of columns in both queries. HTH, Carl

Re: Here's an interesting little problem...

2008-08-26 Thread Carl Von Stetten
Rick, Could you add an additional column to the database table to store a numeric sorting value? Or a second character column with spaces prepended to the single character and double character values (like A, B, AA, AAA)? Carl Rick Faircloth wrote: I need to order query results by

Re: Weird Time Issue Between Linux and Windows Server

2008-08-26 Thread Carl Von Stetten
Randy, Looks like a DST issue on Linux. Carl Randy Johnson - CFConcepts wrote: Hello, The following code displays different dates whether it is ran on a windows machine or a linux machine. form.thedates are javascript times that get passed in. cfset

Re: cfqueryparam and bit field

2008-08-11 Thread Carl Von Stetten
Scott, What cfsqltype attribute are you using in your cfqueryparam? You might try cf_sql_bit. Also, I had to write a custom function to generate bit values for all boolean values. Here's my function: !--- BooltoBit can be used to convert logical boolean values (on/off,true/false,yes/no,

Re: loop over list question

2008-07-17 Thread Carl Von Stetten
Rachel, I believe it would, but you would have to modify your form structure a bit. If you download the files from RIAForge and run them, you'll get a feel for how you might name your fields, and how the data will appear when submitted. Carl Rachel B wrote: Carl, Will Brian Kotek's

Re: loop over list question

2008-07-16 Thread Carl Von Stetten
Rachel, It would still be helpful if you could post a dump of the form scope so we can see the structure of the data being passed into your template. We would likely be able to provide you with more intelligent suggestions than from looking at your query alone. Thanks, Carl Rachel B wrote:

Re: loop over list question

2008-07-16 Thread Carl Von Stetten
Rachel, While this is helpful, can you add a cfdump var=#form# to the top of userform.cfm? Then submit your form with multiple entries, and copy and paste the cfdump results into a message for us to examine. Thanks, Carl Rachel B wrote: Here is the form i am working with. !--- Adds

Re: loop over list question

2008-07-16 Thread Carl Von Stetten
Rachel, You might want to look into Brian Kotek's FormUtils, which I believe is designed to handle just this kind of situation. http://formutils.riaforge.org/ HTH, Carl Rachel B wrote: Carl, I did the cfdump and here is what i got CURRENTDATERESOL on,on CURRENTDATEVERT on,on

Re: loop over list question

2008-07-15 Thread Carl Von Stetten
Rachel, Can you cfdump var=#form# the form scope and paste the output into a message? It would help to see how the form data is constructed. Carl Rachel B wrote: Hey Everyone, well i been trying to figure this out for days but i am having no luck. In my form i am able to add multiple

Re: ComboBox?

2008-06-19 Thread Carl Von Stetten
jQuery Autocomplete? Carl Les Mizzell wrote: I've been searching, but so far, not found anything that I can get to work or does what I need... All I need is a dropdown list that I can type a new value into if what I want (coming from a database) isn't already there. I've seen a few CSS

Re: ComboBox?

2008-06-19 Thread Carl Von Stetten
. -mk -Original Message- From: Carl Von Stetten [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 10:20 AM To: CF-Talk Subject: Re: ComboBox? jQuery Autocomplete? Carl Les Mizzell wrote: I've been searching, but so far, not found anything that I can get to work

Re: cfc question...

2008-06-16 Thread Carl Von Stetten
Rick, A CF Admin mapping would be a reasonable approach. For example, you might create a mapping /c21ar_cfcs (or whatever you want to name it) that points directly to e:\inetpub\webroot\c21ar\components. Then, anywhere you need to access the CFC, you would use c21ar_cfcs.agent. Or in your

Re: [CF-Dev] WDDX-JSON plugin for jQuery ?

2008-06-10 Thread Carl Von Stetten
Peter, Have you considered skipping WDDX and going straight to JSON? If not, check out both AJAXCFC and JSON.CFC. Carl [EMAIL PROTECTED] wrote: A bit more background info. might be good but have you looking at AJAXCFC? The Robert Gordon University, a Scottish charity registered under

Re: Problem with onSessionStart

2008-05-28 Thread Carl Von Stetten
, May 27, 2008 at 5:21 PM, Carl Von Stetten [EMAIL PROTECTED] wrote: Ray, I did post the entire CFC in my reply to your earlier post. I added the cflog to the OnSessionStart, and if I start my application from a fresh browser window (newly launched), it puts an entry into the log, along

Re: Problem with onSessionStart

2008-05-28 Thread Carl Von Stetten
Ray, Apparently putting the contents inline and sending from my email client isn't working, so I'll try through the web interface. Here are the contents (note the last two functions are commented out as I haven't implemented them yet: cfcomponent displayname=Application

Re: Problem with onSessionStart

2008-05-28 Thread Carl Von Stetten
is to simplify. Remove 100% of the stuff you don't need for right now. All the stuff in onRequestStart, shoot, remove all the methods except onSessionStart. Make the CFC as simple as possible and just ensure you can dump the CFC in the session scope. On Wed, May 28, 2008 at 11:19 AM, Carl Von

Re: SOT: pastebin.com - Tool for posting/sharing code - collaborative debugging

2008-05-28 Thread Carl Von Stetten
Gerald, Thanks. That would have been very handy indeed! I'll try and use it next time I have to post more than a few lines of code. Carl Gerald Guido wrote: I see a lot of people posting code and/or having problems doing so (like Carl was having today) and I thought I would share this

Problem with onSessionStart

2008-05-27 Thread Carl Von Stetten
I'm having a problem getting a session variable to initialize using the onSessionStart method of Application.cfc. I'm trying to instantiate a cfc object named rd into the session scope, and initialize it. I'm using J2EE sessions. No matter what I do, the rd session variable is not created.

Re: Problem with onSessionStart

2008-05-27 Thread Carl Von Stetten
Why do you have locks? CF single threads these methods automatically. Secondly, I'd get rid of the cfreturn even though it isn't doing anything. Lastly, try renaming your application temporarily. That would force new sessions to be created. On Tue, May 27, 2008 at 11:35 AM, Carl V Ray, Thank

<    1   2   3   >