RE: Join vs Union Perference

with a join, you'll get the records that "match" something in the two tables. With a union, the first table is output and the second table is output right behind it so it appears to be One continuous table. The records don't match the fields from one table to the other. Hope this is making

CF Verity Index Error on PDF's

Hello All Yesterday our CF Verity errored out with the folowing message. "Error","TID=639","08/16/00","14:32:57","216.32.72.194","Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)","Error occurred in tag CFINDEX Unexpected error occurred while processing tag.The error occurred while

database

City/County/state URL http://www.naco.org/counties/queries/city1_res.cfm?STATECODE=md I have a state/county database I could send you. I don't have a state/country db. Let me know if you'd like the db I have and I'll send it over. Bonnie R. -Original Message- From: Bonnie Betts

identifying a query

Hello, I have a problem with users running a query, then selecting different options and running the query again. The user then backs up their browser to the first query results and hits the "next page" button and the code errors out because of the rowcount being different than the last query

RE: E-commerce Security, for the non programmer..

The shopping cart/cc portion MUST be under an SSL, note the closed "lock" at the bottom of the browser and HTTPS instead of HTTP. Check that the CC no is NOT going over the URL (I've actually seen this done). I don't know if there's a way to check, but the CC no should not be going through

RE: SQL and apostrophes

you need to escape the apostrophies with cfset vexperience=Replace(#strEXPERIENCE#, "'", "''", "ALL") then insert the new field into the query string. I've been fighting this problem for 6 months and this is the solution that seems to work best. Preservesinglequotes doesn't work in this

Form Loading

How do you force a form to completely load before letting the user press the submit button? I haven't found much in my documentation yet and the Allaire search isn't working :\ Thanks Bonnie [EMAIL PROTECTED] --

RE: groupcasesensitive attribute question

Make sure when you use the edit feature for the cfmail tag that you uncheck the groupcasesensitivity box since you're not using a group option. It automatically sets this to yes, but since there's no group to group on, it causes your error. I did this this morning to one of my files even

RE: apostrophies troubles

It has the preservesinglequotes as the first try to fix the problem, then the replacenocase as the second try to fix it. Since the preservesinglequotes isn't hurting anything, I left them in. Education is an input box (text) and description and experience are text area's. Thanks Bonnie

Off Topic - programmers will relate

My boss just put this article on my desk, it's enjoyable reading for any web developer http://www.internetworldnews.com/article_bot.asp?inc=070100/7.01UnderDeviss ue=7.01 -- Archives:

apostrophies troubles

Has anyone else had problems getting query insert statements to work with apostrophies in the text? I've had the problem on two different occasions even with putting a preservesinglequote around the offending field. I've finally just did a replacenocase on the apostrophies. I'm running CF

RE: Help With Upgrading From Access 2000 to SQL for my cf site

I've had experience with alot of this. Check into these areas, the field names are not SQL compatible SQL has enough space alloted to it the sql transaction log is not filled up I've actually had to make a CF page to import data to SQL before. Now, if you're using SQL7.0 there's an import

apostrophies

Does anyone else have trouble with apostrophies when submitting fields to an access2000 database? I've put preservesinglequotes around the fields and that didn't stop the problem, so I had to wind up doing a replacenocase and put the ascii equivalent to get around it. It's getting to be quite

RE: Form Verification

you might try something like this... INPUT SIZE= 30 NAME= "fromemail" MAXLENGTH=60 VALUE= "#EDIT.fromemail#" INPUT TYPE="Hidden" NAME="fromemail_required" VALUE="Email may not be left blank." the 2nd input causes the first to be required. Good Luck Bonnie AGS

RE: Able Commerce Help

. Or are you changing the actual structure of the app. Emmet McGovern developer/ Byte Size Inc -Original Message- From: Russell, Bonnie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 6:07 PM To: '[EMAIL PROTECTED]' Subject: RE: Able Commerce Help yes, I've followed their directions

RE: OT: School Days - (was: Lighten things up a little)

Ok, I have an Associates in computer programming and working on a bachelors in computer science. Not having the BA degree has only hurt my career while working for govt contractors.But I have the years of experience to compensate. I think it comes in handy when negotiating salary,

Able Commerce Help

Has anyone had experience using able commerce and customizing for a particular customer. What I need is to have a separate directory for program files for one customer while using the original able commerce program files for everyone else. Everytime I follow the directions to copy the files and

RE: Able Commerce Help

McGovern developer/ Byte Size Inc -Original Message- From: Russell, Bonnie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 2:58 PM To: '[EMAIL PROTECTED]' Subject: Able Commerce Help Has anyone had experience using able commerce and customizing for a particular customer. What I need

RDS properties

Anyone know why I can't get the right mouse menu's to come up? I've checked another machine (I'm using a trackball and it has a regular mouse) neither will bring up the right mouse menu's so I can't configure my RDS's or remove any once their made. I'm using CFStudio 4.5. I've checked the

RE: how to separate 400 query resutls into 20 pages?

There's a tag at allaire called page_thru that works well. It puts a list across the top of your page with page links and increments according to what you set. Bonnie Automated Graphics -Original Message- From: Xing Li [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 11, 2000 4:07 AM

CF Studio RDS question

Hello, I'm running CFstudio 4.5. Could someone tell me how to remove an RDS server. I know this should be simple, and it was in 4.0, but they've moved it for 4.5. Thanks Bonnie -- Archives: