Operation must use an updateable query

Hi there, I have a very simple CF app that is using an MS Access 2000 file as the datasource. The app works fine on my system, but when it is uploaded to the hosting provider, I get an "Operation must use an updateable query" error on a page that inserts information from a form. It's just a

RE: Filemaker on a MAC

I'm very interested in finding out if anyone has used a MAC Filemaker database to drive a site and if there are any compatibility issues with our hosting platform (We have NT4 SP5 servers running MIIS4 and CF4.5 Ent). Or if it just can't be done? It can be done, but FileMaker is

Re: OT: Web Objects Newsgroup

Sorry about this guys, but does anyone know about a good newsgroup or online reference for web objects? This is the best one that I know of: http://www.omnigroup.com/community/developer/mailinglists/webobjects/ You will also find some resources at http://www.stepwise.com Rob

Re: Table Row Background colors not showing in Nutscrape

You need to ensure you write a non-breaking space - "nbsp;" without the quotes - if you are not displaying content in a cell. This is a Netscape "feature". Rob Keniger -- Archives:

Re: Division in Cold Fusion?

I must be looking at all the wrong stuff... but I want to take 2 values and divide them. Try: cfset myval = evaluate(thisval/thatval) Rob Keniger -- Archives:

How much can CF handle?

Hi, I am doing a proposal for a client ATM who has a web site that is currently getting about 6 page views per second in peak time. Do you think it will be possible to handle the load with a single CF/HTTP server running Linux and a separate DB server running MySQL? All images will be stored

Re: pop-up windows and cold fusion

"don't open this window every time", how do I get cold fusion to not launch the window? cfif not isdefined('cookie.visited') script!-- window.open(); //-- /script /cfif cfcookie name="visited" value="yes" Rob Keniger

Re: Create Db table

Go to http://www.citilink.com/~jgarrick/vbasic/database/jetsql.hmtl The SQL syntax for creating Access tables is outlined there in detail. Rob Keniger -- Archives:

Re: Linux connecting to MySQL

I am attempting to create a connection in the ODBC page of the CF administrator to a MySQL database, which exists. My CF server runs as "nobody". My MySQL server runs as "mysql". my database name is "db_test". need to know the following: - what user needs to be set up in mySQL - is that

RE: Client v session with remember me

You could just make sure that if the user clears the check box, their cookies don't persist after they close their browser, by overwriting the cookies with non-persistent cookies: Aha! Very clever. Thanks a lot Dave, I will indeed try this. Rob Keniger

RE: 1 or more dsn's - efficiency?

Books is the main database; should tables be added to this database for daily quotes and for links or is it better to have separate small databases for daily quotes and links Definitely better to have it all in one DSN. Making an ODBC connection to a data source is costly in terms of system

Re: remove white space

try #replace(string,chr(32),"","ALL")# Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

Re: Linux CF Services

Is it normal for a Linux installation of CF 4.5.1 to start about 5 copies of cfserver, cfexec, and cfrdsservice? Is this the equivalent to apache's child servers? Where is this configurable? I've been wondering the same thing - my installation on Linux is also doing this. Anyone?

RE: Browser / desktop resolution

I am going to be frank and apologize to everyone for this. I have been watching this list for 2 weeks and the mass of amounts of email being sent on a daily basis is annoying. There are some really good subjects in some of them but reading through them all is difficult to say the least.

RE: Need your help desperately...

"Scott, Andrew" [EMAIL PROTECTED]wrote: Andrea Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] So which is it? Andrew or Andrea? Or are there multiple personalities all fighting each other? :-) Rob Keniger

Re: Preventing Browsers Cacheing a .cfm file

Is the a code that will successfully prevent a .cfm page from being = cached on a users browser that will work effectively across browsers Yes. You should set up a variable (preferably in your application.cfm) that sets a random number and append that to all your URLs, eg: cfset

RE: CF, ODBC and 64k data

With CF 4.0, you will not be able to submit more than 64k. At CF 4.5, you can do this. You need to go into the ODBC area of the administrator and enable long text retrieval. Bear in mind that there is a definite performance penalty in turning this feature on. Rob Keniger

Re: Return Button To Query Results

If you just want to be able to go back like when you use the "back" button in the browser, do this: input type="button" value="Return to search results" onClick="history.back();" Note that this will not work if you have a couple of pages after the detail view, such as an update template etc.

CFFILE problem on linux

Hi there, I'm trying to get CFFILE working on a linux box. ColdFusion is running as a user called coldfusion which has group write privileges to my HTML directory. If I log in as the coldfusion user I can create directories and files in the HTML directory OK. However, when I try to do a

Re: anchors in IE

Try putting the achor at the end of the URL, like this: BODY onLoad=open("viewlist.cfm?role=#roleanchor#","sidebottom") Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

Re: javascript question

any idea why this doesn't load credcard.cfm? input type="image" src="images/purchase/buynow.gif" border="0" onClick="document.credcard.action=credcard.cfm;document.credcard.submit();" Yeah, you have to put javascript literal strings inside quotes otherwise javascript interprets it as a

Re: Multiple actions from a Form?

Try doing this: form name="theform" method="post" input type="image" src=".gif" onClick="document.theform.action=file.cfm; document.theform.submit();" input type="image" src="f.gif" onClick="document.theform.action=file2.cfm; document.theform.submit();" /form Rob Keniger

Cfinclude or caching?

Hi, I have an application that is going to be getting a fair few hits (about 20-30 page views per second in peak time) and I am trying to make the home page as streamlined as possible. The home page has a "news" section which is to be updated maybe once or twice a day. Now, in performance

Re: Cold Fusion ISP search

Good luck finding a "shared" server with access to CF Administrator OR CFFILE! It's just too big of a security risk. Sounds like you're looking for a dedicated server. If the server admin has correctly configured security sandboxing using CF Advanced security then CFFILE is fine. Some ISPs

Re: clever list boxes

1. Can you make a list box behave this way? I'm sure I've seen web sites with list boxes that also allow you to type characters into the box. They could I use an event to test for a new value or something. What you want is a combo box which is not a standard HTML element. You can

Re: Application.cfm... whats that ?

the cfapplication tag doesn't _have_ to be in the application.cfm file, just ususally is, because thats where it makes sense to put it. True enough, but if you know enough CF to use session variables why would you not know what the application.cfm file is? Rob Keniger

Re: Slightly OT: Dumb HTML question

Hello everyone, I was trying to build a table cell TD with it's own border (apart from the rest of the table) in Netscape 4. I tried TD BORDER=1 and that didn't work, I tried a style sheet and that didn't work either, does anyone know how to do this? Thanks! Give the cell a background color

Coping with load

Hi there, I will be setting up a CF app for a customer who is getting approx 7 million page views per month. The bulk of the pages that are currently served as static pages will be served via a CF app connecting to a MySQL datasource on a separate server. Will a single CF server (suitably

Re: Force database connections to close....

Is there a way to force the database connection to close or to release memory as data is dumped to the client..??? some like connection.close() This would really be a powerful feature to have... If you do a CFQUERY to a table that doesn't exist, the database connection closes. Don't

Re: Session Management

Is it possible to terminate a session when a user closes their browser?? Its easy when a user logs out, or the session times out, it would be nice if you could also do it when the browser is closed. Not really, AFAIK. There is no javascript "onQuit" event or similar - although there is an

RE: Session Management

expire the cookie immediately This won't work if you are using CF's session management because you don't specifically set cookies - it either uses CFID and CFTOKEN stored as a cookie OR as a URL argument. The expiration of the cookies is set by ColdFusion and is tied to the session timeout

Re: Calculate Function on a form?

I have exactly this setup in a few sites - basically I have a form button that submits the form back to the same template with the form fields filled with the new calculated values. You can change the action of a form using javascript like this:

Re: Create TABLE in MS Access

This might be a little off topic: I am wondering if anyone knows how to specify field properties when using the Create TABLE or Alter TABLE SQL statements in MS Access. I am writing some code to create a few tables on the fly, and it would be very handy to be able to specify things like

Re: limiting upload file size

I want to not upload at all if the file is bigger than 1MB. How can this be done? I can't think of a way to do this, but while I was looking around for a solution I found this page about file upload fields which is quite informative: http://www.hut.fi/u/jkorpela/forms/file.html I hope this

Re: encrypted code

http://shroom.dv8.org/bmp/cfdecrypt Rob Keniger -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a

Re: encrypted code

Might want to ammend that : http://shroom.dv8.org/bmp/crypt.cgi (the other link gives a 404) Just checking you were awake ;-) Rob Keniger -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe

Re: Mac File Uploads + extensions

How are people dealing with files uploaded by AppleMacs. How can you tell what type of files they are ?? What sort of things are you allowing users to upload? Mac files can be anything - on the mac they store information about what the file is in a separate "fork" or file along with the main

Re: Textarea formatting question

Hi - A quick question - I'm using a few textarea blocks in my form for users to submit large chunks of data to a memo field in an access database - this data to be submitted is formatted with blank lines, tabs, carriage returns, etc. - how do I retain formatting so that when the user views

Re: convert caps to small

Is there a tag that can instantly convert all the text that im outputting into all small letters .. Rather than some of them being in capitals ? Umm, yeah.. Lcase("INSERT YOUR CAPS STRING HERE") HTH Rob Keniger

Permanent variable storage

Hi there, I've got an application where I have several pieces of data that the client needs to be able to maintain using CF. These are things like the email addresses that various form output is sent to, the prices for certain products and a bit of "blurb" for the intro page. My question is

Re: escaping special characters between cfoutput/cfoutput

This is most likely a stupidly simple question, but I can't seem to find a solution in the reference books. How can a place a "#" inbetween cfoutput tags? Yeah, it's pretty easy. use ## instead of # HTH Rob Keniger

Re: Permanent variable storage

Thanks everyone for the responses. why do you think application scope is a bad idea? even after server restart your application will be intended to reinitialize thru application.cfm... Yes I know, but if the variables need to be changed they must be stored elsewhere in order for