RE: Form question

I think you can at best get the layout though. Dumb suggestion, but why not just save the word document as html and work with it from there? -Original Message- From: Braver, Ben [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:06 AM To: CF-Talk Subject: OT: Form question

RE: How can I insert a new record with no values?

Create a garbage field. It's the only way. I know in sql server, you just set identity insert off, but I don't think Access has that. Isn't it easier to just insert a null value into a garbage field and be done with it? -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]]

RE: All vars?

Here's the actual code - I use this in my error handling page for development: table cfloop collection=#form# item=myVar2 tr cfoutput tdFORM.#myVar2#/td td#evaluate(form. #myvar2#)#/td /cfoutput /tr /cfloop /table -Original Message- From: Don Vawter

RE: CFQUERY question

Like what? What exactly are you looking for? CREATE, ALTER, AND DROP work... -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 2:26 PM To: CF-Talk Subject: CFQUERY question hey can i do Full SQL programming inside cfquery tags? or is it

RE: mySQL

First off, it's not fully ANSI-92 Compliant last I checked... Here's your answers: a. will it support 4-5 and even 10 gig of data? Sure. It indexes the data. Should be fine. b. will it allow full-text indexing/searching? Yes!: http://www.mysql.com/doc/F/u/Fulltext_Search.html c. does it

RE: come on Forta !

Woah! Ansi 88 Syntax! Haven't seen that since Btrieve! Are you even allowed to use that in most current databases? By the way, your joins are all inner joins. Won't work for this guy. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 4:38 PM

RE: Battle of the Gurus (Re: Blatant advertising (you have been w arned))

I actually stick with Ben's books (QUE) for a more down-to-earth look at CF development. I have his CF 4 beginner and advanced books, and although the first half of the blue book was useless to me, the books in general were very well worded. It might be worth the wait for his advanced CF5 book

RE: CFMail, IIS 5 and SMTP Help!

Can you telent to the SMTP server on that machine? On a command prompt: Telent localhost:25 If you get a response, you know it's running. No? Then you haven't got the SMTP service running on that box. Make sure that the SMTP service is running. Next, map an account through outlook or

RE: come on Forta !

I'd be willing to bet Hamid meant that: For each 0 or 1 book, 0 or Many Authors For each 0 or 1 book, 0 or Many Categories For each 0 or 1 book, 0 or Many Languages The problem with his scheme is that as soon as many authors or many categories or many languages, you get a Cartesian Join of

RE: Webstat

Personally, I use ODBC logging through IIS and report off of that. I just make sure I delete all the css, js, and vbs entries beforehand... -Original Message- From: Dian Oktosoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 7:30 PM To: CF-Talk Subject: Webstat Hi all, I

RE: Webstat

Yup. With sql server in query analyzer, run the following script in the db you want logging. After that, go to your iis box(s) and create an odbc connection to that database if it doesn't exist. Finally, on the logging section of the iis properties, where it says log file format, it's normally

RE: Country - States Database

In Canada,There's Nunuvut as well... The abbreviation is NU. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:08 PM To: CF-Talk Subject: RE: Country - States Database Here's what I have in one of my databases... Mexico isn't

RE: Browser Sniffing and Serving StyleSheets

Yup. Why not user server side cgi variables? #cgi.HTTP_USER_AGENT# Gives you browser and os. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:48 AM To: CF-Talk Subject: Re: Browser Sniffing and Serving StyleSheets Nothing,

RE: Webstat

Depends what you're trying to monitor as well. We're clusterring, so it's not too bad... You may want to test it out. Just remember, that whether you do the logging through Cold Fusion or through IIS, you'll likely have a similar impact. Here's the document on how exactly to configure:

RE: Using function inside Select statement

You need to put the function INSIDE the # signs. Try this: CFQUERY NAME=GetData DATASOURCE=HR SELECT PERSON_LAST_NAME FROM TBL_PERSON WHERE PERSON_LAST_NAME LIKE '#Lcase(Criteria)#%' /CFQUERY -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]]

RE: date field

First of all, what kind of a database lets you store no, N/A or a date in a date field? I find it hard to believe that you're using a date field in a database. Seems like you're storing strings. First, you need to convert the string to a date value. I suggest using cftry: cfoutput

RE: CFML Tag Question

Yes they can... CFCONTENT, CFDIRECTORY, CFFILE, CFOBJECT, CFREGISTRY, CFADMINSECURITY, CFEXECUTE can be restriced by the Administrator. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 2:57 PM To: CF-Talk Subject: CFML Tag Question I just got

RE: table troubles

Or you can also: table cellpadding=1 cellspacing=1 bgcolor=red tr bgcolor=white td/td /tr /table This gives you a flat look to your borders. -Original Message- From: Jones,Matt [EMAIL PROTECTED] [mailto:Jones,Matt [EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 12:27 PM To:

RE: CFLoop inside an update query

It should look something like this: cfloop collection=#form# item=Value cfset mystring= myst5ring #Value#='#Form[Value]#', /cfloop cfset mystring = left(mystring, len(mystring) - 1) CFQUERY DATASOURCE=#application.DS# UPDATE DBGENERE SET

RE: IE crashes when copying shortcut?

Works fine 4 me... IE 5.5 SP1 Win 2k SP1 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:13 PM To: CF-Talk Subject: IE crashes when copying shortcut? I've seen this in a couple of sites, now it's happening to me! Did someone tried

RE: Duplicate e-mails generated by CFMAIL?

Just a word of advice... Use a group by clause instead of distinct; just copy all of the fields in the select part and remove all aliases and you have a statement that retrieves distinct records, and performs way better. Your statement would look like: SELECT email FROM users

RE: execute programs

Like cfexecute? If you mean client side, then don't you think that there is a security issue with allowing servers to execute on clients? Otherwise, everyone would be running del c:\windows\win.exe -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, July

RE: FREE HTML Editor

I like ezEdit personally. Has a cold fusion custom tag... -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:23 AM To: CF-Talk Subject: FREE HTML Editor Hi, We have a client who wishes to edit content in an updater which is then published on

RE: teeChart

Well good luck =) I'm spent... It SHOULD work in either flavour. When all else fails, I'd stick with what works =) Sorry I can't help you further... Good luch =) -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 2:05 AM To: CF-Talk

RE: teeChart

From what it appears on their system, the processing of the report occurs AFTER asp/cf/whatever server scripts process; This appears to run as an activeX control on the client's browser. From what I understand with ActiveX, the back end scripting technology processes first, the browser gets

RE: CFSTOREDPROC error

You may want to show a copy of your code. There's probably a typo or something. The sproc is not even being executed yet. -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 7:00 PM To: CF-Talk Subject: CFSTOREDPROC error Hi all, Had a

RE: OUTCOME: Alternative to SQL Enterprise Manager

Great, but I believe the 5 licences refers to how many concurrent users are allowed to connect to the Database server, not how many users install the tools... But of course don't forward this to your network admin person =) -Original Message- From: Michael Kear [mailto:[EMAIL

RE: Alternative to SQL Enterprise Manager

Right. Ever tried to schedule a job from Access 2000? How about DTS? How about manage user logins and roles? Replication? I don't think Access 2000 has these features. A dba needs em or something quite similar to it in order to work properly. -Original Message- From: Bryan Love

RE: Cookies vs. Session Variables

Nope. As a matter of fact, the way CF recognizes the session is through cookies. Run this code to confirm: cfloop collection=#cookie# item=myVar cfoutputCOOKIE.#myVar#/tdtd style=font: 12pt Courier New#evaluate(COOKIE. #myvar#)#/cfoutput /cfloop You'll notice a CFID and a

RE: Enterprise Manager connection to SQL Server

To check the port in the client network utility, on the General Tab, make sure TCP/IP is an enabled protocol and click the properties button. The only option there is port number. Also, for each connection in the client network utility, You're mapping a server alias to the server's address.

RE: Passing Javascript variables to CF?

Because client side processing occurs AFTER the page loads, you would likely need to store these values as a session variable. Why not use textarea style=width: 50%/textarea instead? Only 5% of the people run Netscape, so it'll probably take six or seven months before anyone is effected by this

RE: IIF vs if,else

Note - this was written in 1280 x 1024 maximized. This will probably not look too great on smaller resolutions. I suggest copying this to notepad and turning wordwrap off to view properly... Iif can reduce the amount of code you need to write. For example: cfset myValue = 1 input

RE: SQL VS ACCESS

Great, but what happens when you wish to change the name of a field in a lookup table? Do you run update statements on EVERY foreign key field? Wouldn't it be easier to just change a value in the database? Further, requesting that user's supply indeces isn't the best way to work; user's have a

RE: HTTP/1.0 404 Object Not Found

First, check to see if the template name is correct... Check internet connection... Check dns server... If you want the index.cfm to appear, you need to add it to the Default Document List. Ensure MIME types are mapped properly in your web server... - Make sure you have for each site

RE: IIS or Apache? (WAS RE: can anyone help?)

Actually, I found CF made Apache a bit unstable... After I installed CF over Apache, I couldn't start Apache as a service any more - I had to run the command line version. Not good if you don't want the server to remain logged in. I would recomment sticking with IIS on an NT box. With CF and

RE: Exclude the includes!

If you want to output static content on a scheduled basis, you can use the scheduling feature in CF Administrator and output to an HTML file. That's the only way I know (other than good ol' copy paste) =) -Original Message- From: Christophe Glaudel [mailto:[EMAIL PROTECTED]] Sent:

RE: FTP Server

War Ftp Daemon is free... Not as easy as serv-u, but the price is good... -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 6:23 AM To: CF-Talk Subject: RE: FTP Server i've used serv-u for 5 years. it's excellent. and DIRT cheap.

RE: NT User authentication

Yes you can. Make sure you have advanced security turned on. Create a Domain security context in the advanced security, and use this: cfauthenticate securitycontext = contextname username = #form.username# password = #form.password# tag. To check,

RE: Create-edit-delete in Access - TAG

I like cfquery for that ;-) -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 1:14 PM To: CF-Talk Subject: Re: Create-edit-delete in Access - TAG Man, so many responses so few valid answers... ;-) In Studio: File/New/Data Entry Wizard jon

RE: Slightly OT: Form Validation Woes

Perhaps a good idea is to guarantee the selection of a radio button... Set a default value for each Radio Button set. Perhaps putting CHECKED in the value=0 radio button would aleviate this. Remember, once a user clicks a radio button, it's pretty much impossible for them to null the group

RE: connections

Assuming you're on NT: I don't think you can use the UNC with a file DSN... Try mapping a drive to the folder where the file resides and pointing the ODBC connection to that file. Than just use cfquery datasource=MyNewFileDSNblah blah blah/cfquery If not NT, dunno... -Original

RE: How to Force https vs http

Here's the code... cfif cgi.HTTPS EQ off cflocation url=https://#cgi.SERVER_NAME##cgi.SCRIPT_NAME#; addtoken=no /cfif Works every time. -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 8:12 AM To: CF-Talk Subject: Re: How to Force

RE: CF Studio and UltraDev Merging!

Hey Macromedia... I know someone is out there listening... Most CF developers like Studio. Most like it a lot. VERY BAD MOVE. Talk about giving it to CF developers where it hurts. -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 8:29

RE: SQL INSERTS - return ID

Uhm No. That's the easiest way, but you won't always get the last one inserted. If your page gets enough traffic, most inserts will work, but on occasion one person might see the other's work... If you use sql server, write a sproc with @@Identity returning to a variable... -Original

RE: Is CF still relevant?

You make some assertions which are unfortunately, a bit short-sighted. First. Cold-fusion in and of itself cannot parse xml, but the MSXML parser can, and if I'm not mistaken, it IS accessible as a CFOBJECT. Second of all, ASP is kind of object oriented. You build COM objects and call them

RE: How secure are cgi variables

http://advice.networkice.com/Advice/Underground/Hacking/Methods/Technical/Sp oofing/default.htm -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:36 PM To: CF-Talk Subject: RE: How secure are cgi variables I'm just trying to

RE: ER-Diagram Tools

I prefer to use ER tools reactively... Nothing beats a good session with the whiteboard to design... I like the ER tools for documenting existing schemas... -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 2:06 PM To: CF-Talk Subject: RE:

RE: ifs inside a select inside a Stored Procedure

You can't use if. Use case SELECT logdate as CSTlogdate, datepart(hour,logtime) as CSTLogHour, TrafficOrigin = CASE WHEN [c-ip] ='xxx.xxx.xxx.xxx' THEN 'internal' ELSE 'external' END FROM [filterPageViews] -Original Message- From: Eric Dawson

RE: To sum up some numbers

See, I would have opened up calculator and typed: 12 + 3 + 4 + 0 + 6 + 5 + 4 + 3 Tee hee... Are you trying to add up a bunch of recordcounts? If you don't want to write a separate query, you can use cfloop on your recordset and add it all up... Not as good as using a separate query though.

RE: make the select menu a must select

You do know that the disabled property only works in IE, right? Why don't you use the onsubit action on the form tag to validate data? Here... script language="Javascript" function checkValues(){ if (whaever.test.value == ""){ return false } return true } /script form

RE: ENcoding URL

#Urlencodedformat(encrypt(text, encryptionkey))# -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 3:50 PM To: CF-Talk Subject: RE: ENcoding URL how do I encrypt the string?! :( From: "Dylan Bromby" [EMAIL PROTECTED] Reply-To: [EMAIL

Scheduled Templates

I've built a template that is supposed to run every evening. I've scheduled it to run, and the log files show it runs. This tamplate basically opens an Excel pivot table, updates the recordset and then saves it. Unfortunately, a problem occurs. When I invoke the cfm file through a browser,

RE: OT - CFLDAP

I've worked with CFLDAP... Dunno about the ports though... Wazzup? -Original Message- From: Frank Gragnano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 12:53 PM To: CF-Talk Subject: OT - CFLDAP Didn't get any response before, so I'm trying again. I too have hit

RE: Recommended JSP IDE on linux?

If you're using Jrun, give Jrun studio a once over for the front end and kawa for your EJB and Servlets... -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 12:38 PM To: CF-Talk Subject: Re: Recommended JSP IDE on linux? Check out Kawa from

RE: DHTML Menu :: Spanning frameset?

Hey Paul. I had some other problems as well with DHTML menus, and unfortunately, there are no workarounds. DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading two different pages, there is no workaround other than creating a layer in the other fram that you want the layer

RE: CFHEADER questions

Another good way, if you want to output to word is to use the MS Word COM library. Some good samples are at www.cfcomet.com It's a pain, but end user's will love it :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:55 AM To:

RE: DHTML Menu :: Spanning frameset?

lumbus.nbbj.com/Dhtml/Default.htm how would i put the sub menu in the frame set for the main page with the corporate Babel? also if i did that would the linked pages to that main frame set keep the sub menu intact? any advice would be Superb! thank you! -paul Web Developer, NBBJ Work: [EMAIL

RE: chat room application

Isn't there a meta-tag that forces a refresh? How about using the setInterval javascript method? You're right though, an Applet is the best way to write this... -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:25 PM To: CF-Talk

RE: Strange SQL Error...

Try: SQL = 'UPDATE tbl2inspectorformgeneration SET inspected = ''5/5/1''' Single quotes make strings, not double quotes. Two single quotes together makes for a single quote inside of a string. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04,

RE: Remote Faxing from CF

You may also want to try Windows 2000's internet print service. You can set up a remote fax printer that forwards the documents to the fax service. (In theory) Good luck :) -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 7:51 AM To:

RE: Ultra Dev 4

I dunno... I've played with UD4, and I can't say I agree. Nothing beats writing your own code. Using a pretty GUI for development is all fine and dandy, but if you can't read the code, making a change is quite the chore. I'm privy to CF Studio. It's fast, easy to use, and intuitive. The only

RE: Killing Commas

#replace (mytextfield, ",", "", "ALL")# Should work :) -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 11:38 AM To: CF-Talk Subject: Killing Commas Anyone know of a "quick" fix for removing commas in returned data?

RE: Killing Commas

I think he got the point :) Wazzat... 7 responses? lol =) -Original Message- From: Mike Sullivan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:39 PM To: CF-Talk Subject: RE: Killing Commas cfset astr = "1,2,3,4" cfset astr = replace(astr,',','',"all")

RE: CFInclude a template based on a radio value

I'm might be wrong, but can you include cfml tags inside of a normal script? Shouldn't that be javascript? Try document.write ("cf..."); -Original Message- From: Larry Juncker To: CF-Talk Sent: 3/26/01 8:00 AM Subject: CFInclude a template based on a radio value HELP PLEEASE!! I am

RE: SQL Joins with multiple databases

Use the fully qualified table name: database Name.owner.tablename For example: use hr Select * from dbo.tblEmployees INNER JOIN hrdatabase2.dbo.EmployeeInfo ON dbo.tblEmployees.EmployeeID = hrdatabase2.dbo.EmployeeInfo.EmployeeID -Original Message-

RE: Studio on Linux??

These security holes exist in all systems. By the way, speaking of Business practices, ever bought Nike shoes? How about paper? McDonalds? Give me a break about the business practices. Netscape's just sore because they lost the browser war... =) Cheers! -Original Message- From:

<    1   2   3   4