Operation must use an updateable query

2000-09-07 Thread rkeniger
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 s

RE: Filemaker on a MAC

2000-09-04 Thread rkeniger
> 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

Re: OT: Web Objects Newsgroup

2000-09-01 Thread rkeniger
>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 Keni

Re: Table Row Background colors not showing in Nutscrape

2000-08-24 Thread rkeniger
You need to ensure you write a non-breaking space - " " without the quotes - if you are not displaying content in a cell. This is a Netscape "feature". Rob Keniger -- Archives: http://www.mail-archive.com/cf

How much can CF handle?

2000-08-23 Thread rkeniger
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 on

Re: Division in Cold Fusion?

2000-08-23 Thread rkeniger
>I must be looking at all the wrong stuff... but I want to take 2 values and >divide them. Try: Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http:

Re: pop-up windows and cold fusion

2000-08-22 Thread rkeniger
>"don't open this window every time", how do I get cold fusion to >not launch the window? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

Re: Second Request for help!

2000-08-22 Thread rkeniger
>I want to know if you can run two instances of CF studio at the same time? Okay, but why do you want to? Perhaps there is a better way to approach whatever problem you have? Rob Keniger -- Archives: http:/

Re: Create Db table

2000-08-21 Thread rkeniger
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: http://www.mail-archive.com/cf-talk@houseo

Re: remove white space

2000-08-16 Thread rkeniger
try #replace(string,chr(32),"","ALL")# Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf

RE: 1 or more dsn's - efficiency?

2000-08-16 Thread rkeniger
>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 syst

Re: How to prevent the browser from REPOSTING

2000-08-16 Thread rkeniger
>I have a page the automatically opens a new window using JS when it is >downloaded, but I don't want this to occur if the user leaves the page and >goes back to it. Try setting a cookie to record that the user has already been to the page. Rob Keniger -

RE: Client v session with "remember me"

2000-08-16 Thread rkeniger
>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 -

Client v session with "remember me"

2000-08-16 Thread rkeniger
Hi everyone, I am trying to implement a user registration system. I have done this before for clients using either client or session variables, depending on the need. This particular client wants to have a "save password" checkbox on the registration form so that if the box is not checked, the

Re: Linux connecting to MySQL

2000-08-16 Thread rkeniger
>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

RE: Browser / desktop resolution

2000-08-14 Thread rkeniger
>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. M

Re: Linux CF Services

2000-08-14 Thread rkeniger
>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: Preventing Browsers Cacheing a .cfm file

2000-08-10 Thread rkeniger
>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: Click here t

RE: "Need your help desperately..."

2000-08-10 Thread rkeniger
"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: CF, ODBC and 64k data

2000-08-09 Thread rkeniger
>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

2000-08-08 Thread rkeniger
If you just want to be able to go back like when you use the "back" button in the browser, do this: This will cache the query for five minutes. Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@

CFFILE problem on linux

2000-08-06 Thread rkeniger
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 into

Re: javascript question

2000-08-02 Thread rkeniger
>any idea why this doesn't load credcard.cfm? >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 variable. Try this: Rob Keniger ---

Re: anchors in IE

2000-08-02 Thread rkeniger
Try putting the achor at the end of the URL, like this: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Multiple actions from a Form?

2000-08-01 Thread rkeniger
Try doing this: Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a me

Cfinclude or caching?

2000-07-26 Thread rkeniger
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 terms

Re: Cold Fusion ISP search

2000-07-18 Thread rkeniger
>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

2000-07-17 Thread rkeniger
>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

Re: Application.cfm... whats that ?

2000-07-13 Thread rkeniger
>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: Application.cfm... whats that ?

2000-07-13 Thread rkeniger
> Yeah ... our site does use a lot of session variables ... but is it necessary > to have this file .. How did you set up session scoped variables without using the application.cfm file? Normally you need a tag in your application.cfm file to turn on session variables. Or have I complet

Re: Slightly OT: Dumb HTML question

2000-07-13 Thread rkeniger
>Hello everyone, I was trying to build a table cell with it's own border (apart from the rest of the table) in >Netscape 4. I tried 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 which is th

Coping with load

2000-07-11 Thread rkeniger
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 spec

Re: Force database connections to close....

2000-07-10 Thread rkeniger
> 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. Do

RE: Session Management

2000-07-07 Thread rkeniger
>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 val

Re: Session Management

2000-07-07 Thread rkeniger
>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 "o

Re: What am I doing wrong?

2000-07-03 Thread rkeniger
>The ## around the DSN are valid, especially if the #dsn# is a variable that >contain the real DSN. This variable could be set just about anywhere, but >is usually done in the Application.cfm (or other similar file) using the >syntax: > I do the same, but I have always used . Are there any

Re: Calculate Function on a form?

2000-07-03 Thread rkeniger
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: onClick="document.formname.action='thispage.cfm?a

Re: encrypted code

2000-07-02 Thread rkeniger
>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: encrypted code

2000-07-02 Thread rkeniger
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=lists&body=lists/cf_talk or send a messa

Re: limiting upload file size

2000-07-02 Thread rkeniger
>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: Create TABLE in MS Access

2000-07-02 Thread rkeniger
>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: Mac File Uploads + extensions

2000-06-28 Thread rkeniger
>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

2000-06-27 Thread rkeniger
>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: "Permanent variable" storage

2000-06-21 Thread rkeniger
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 application.

Re: escaping special characters between

2000-06-21 Thread rkeniger
>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 >tags? Yeah, it's pretty easy. use ## instead of # HTH Rob Keniger ---

"Permanent variable" storage

2000-06-21 Thread rkeniger
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 wh

Re: convert caps to small

2000-06-20 Thread rkeniger
> 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 --