Re: MS Access JOIN Error

I don't know if this will help any but you have missing and mis matched quotes. 52 log.Supervisor AS Supervisor, i suppose Supervisor should have double quotes around it as you have with the previous variables! FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' what's this last

Re: Replace #'s Function!!

#Replace(code, #chr(35)#, , ALL)# sabrina - Original Message - From: bfalloon To: CF-Talk Sent: Thursday, May 10, 2001 10:06 AM Subject: Replace #'s Function!! Hello all, I've encounter a stumbling block... I'm performing a CFFILE action to read a text document

Re: CFLOOP question

How about if you put # sign's around insert_counter in the first cfswitch expression? Heidi --- JB Mentzer [EMAIL PROTECTED] wrote: Hi all I'm attempting to overwrite the index value of a CFLOOP from within the loop: CFLOOP FROM=1 TO=288 INDEX=insert_counter STEP=1 !--- skip gaps

OT: Windows 2000 Professional, scheduled tasks and locking the co mputer

I've got 3 scheduled tasks set up in Windows 2000 Professional. If the computer is locked at night, all 3 tasks run OK the next morning. However, if it's locked (Ctrl-Alt-Del) at the weekend, the events run early Saturday morning but then don't run again on Sunday and Monday morning. When the

Re: CF-Studio registration number

o.k. Now I understand your point. When I do this I get the message: This update requires a prior installation. And then the installation process is aborting. So maybe I have to go and get the real CD somewhere. :-) Uwe - Original Message - From: Tom Davison [EMAIL PROTECTED] To: CF-Talk

RE: Uploading a file

ACCEPT is an optional attribute that exists to exclude any file types not listed in that parameter. Leaving it out should not affect the upload. If you are uploading through a form have you set the correct MIME type in the form's ENCTYPE attribute? Tristram Charnley

RE: Watchguard Firewall II stripping CGI variables?

I'm not sure what version of WG are are using, but either way you should be able to go into the policy manager and set up your own rules for port 80. I would recommend though, to continue using the http proxy if thats what your doing and try to adjust the CF code to conform to the

Strange MDAC 2.6 Problems on Win2k

Hi, i have two problems with MDAC 2.6 on Win2k when accessing an Access 2k db from CF 4.5 SP2. 1. On one page I insert data to a table and do a CFLOCATION rigth after that. Then on the secont page I display that table. On earlier MDAC-Versions that worked great, but on 2.6 it seems like ODBC

RE: cfloop vs cfoutput - THE WINNER IS...

Seems to me no-ones 100% sure.           I've found cfloop to execute better overall in most situations when I am working with very large amounts of data, Chris. I don't generally see much difference in execution time between the two, in any other situation (and cfoutput

RE: cfloop vs cfoutput

Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. OK, I know you've posted a Winner post, but here's the reasoning behind why CFOutput is slower than CFLoop When you run a

RE: Replace #'s Function!!

try this and see what happens... cffile action=READ file=d:\code.txt variable=code cfset code = Replace(code, ##, , ALL) cfoutput#code#/cfoutput Chris -Original Message- From: bfalloon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:07 AM To: CF-Talk Subject:

Insert query inserting a record into multiple tables

Is this possible ? The same datasource, the same form field different tables. Cheers Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your

RE: Insert query inserting a record into multiple tables

2 insert statements needed here -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/

RE: Email List Servers

VOPmail (vircom.com) is our mail server of choice. It's list functions, though not all inclusive, are good enough. The price is very reasonable for a full featured mail server. However, it sounds like that is not what you are looking for. Perhaps you should take a look at Mercury (pmail.com).

RE: Insert query inserting a record into multiple tables

Sure cfquery name=First datasource=MyDatabase insert into tableone(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#) /cfquery cfquery name=Second datasource=MyDatabase insert into tabletwo(fieldone,fieldtwo) Values('#form.field1#','#form.field2'#)

RE: UK-based ColdFusion training course for network administrator s

You might want to check out Highlander.co.uk I did the advanced course there, they might well do a network administrators one as well. Thanks... will do. -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~

RE: MS Access JOIN Error

Wow, that did it. I thought I had tried every combination of brackets, prens, quotes and double quotes. Thanks, this is the first time I've used a join so I wasn't really sure Access supported it or even if that exactly what I wanted (It is). Another strange thing if I change OLE DB

RE: UK-based ColdFusion training course for network administrator s

You might want to check out Highlander.co.uk I did the advanced course there, they might well do a network administrators one as well. Thanks... will do. Just noticed (for anyone else that's interested) that their web site says there will be a ColdFusion Server Administration course

RE: Insert query inserting a record into multiple tables

So there is no way to do it in one query then ? I have done it in two already but, it's just one of those burning questions I had to ask *L* Thanks, -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:19 To: CF-Talk Subject: RE: Insert query

RE: Insert query inserting a record into multiple tables

There is another way.. You could insert the data into one of the tables and then have an insert trigger on that table which automatically inserts the same data into the second table. However you can only do this if every time you insert into table 1 you want the same data to go into

Ecometry and Cold Fusion

Hello Everyone, Does anyone have any experience working with Ecometry and Cold Fusion? My workplace has decided to purchase the ecometry product and wants to integrate its capabilities with our current webiste, all CF based. Any comments and information will be most appreciated. Thank you

RE: Insert query inserting a record into multiple tables

Sorry not in one CFQUERY -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:41 AM To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables So there is no way to do it in one query then ? I have done it in two already

RE: Pinging an email address

1. an MX record is a DNS entry for a mail server 2. on most systems you can use telnet xxx.xxx.xxx.xxx 25 3. next you would have to type HELO 4. VRFY or EXPN (username) end. SMTP 101 :) PEREZ, RICHARD RINGO (SBCSI) [EMAIL PROTECTED] on 05/09/2001 04:35:12 PM Please respond to [EMAIL

Re: Wrong permissions on a Sun Server

We use Studio (with the FTP Server connection to our Sun CF Server) with no problems. All the directories and files are owned by root, and the group is develop (develop is the group of all developers). The permissions on all directories and files is 775 (rwxrwxr-x). The CF server runs as

Re: CF-Studio registration number

do you have the 4.52 eval installed on the system? It should see that and install over it. This is what I did. Tom - Original Message - From: CF-Talk (SD Solutions) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 3:40 AM Subject: Re: CF-Studio registration

RE: Insert query inserting a record into multiple tables

Ok, thanks for your help. My curiosity is satisfied. Cheers, Darren -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 13:49 To: CF-Talk Subject: RE: Insert query inserting a record into multiple tables There is another way.. You could insert

Post-Spectra Content Management Systems??

I'm sure this has been discussed already, so apologies up front. We are a web co that has been developing Spectra apps for our clients mainly because of its content management (CM) functionality. With the demise of Spectra, does anyone know of a reliable and robust ColdFusion CMS that is

RE: Uploading a file

Thanks for all your help. It was indeed a server problem. We have about 5 sites on one server ; (. We have ported site to a dedicated server and all is now well. Thanks guys. Nick. -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 10:11 To: CF-Talk

Re: Replace #'s Function!!

that's what I use. very efficient for replacing long texts and html/cfm code on the fly/ Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: CF-Studio registration number

Yes. I have 4.5.2 EVAL Although it might not work on Win2000, does it ? Did you try it on Win2000 ? Uwe - Original Message - From: Tom Davison [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 3:04 PM Subject: Re: CF-Studio registration number do you have the

Re: CF-Studio registration number

No I did not do it on 2000, I have NT 4.0 workstation. Sorry that it don't work for you. Tom - Original Message - From: CF-Talk (SD Solutions) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 8:27 AM Subject: Re: CF-Studio registration number Yes. I have

RE: Post-Spectra Content Management Systems??

I spent 20 mins looking around trying to find information on the 'demise' of Specta and did not find a thing. I am curious where you obtained this information, as far as I can tell Spectra is still a completely viable product. Chris -Original Message- From: Steve Vosloo [mailto:[EMAIL

RE: Post-Spectra Content Management Systems??

Steve, Are you aware that spectra is not going to be dead entirely It may not be available commercially, but it will be being supported by Macromedia on Open Source for, I believe, the next two years. If you want to see the email that Charles Teague sent out with regards Macromedia's

RE: Post-Spectra Content Management Systems??

have you had your head buried in the sand recently?! Spectra is being discontinued after the next maintenance release [1.5.1] that will be final release, it will be supported by Macromedia for 2 years and then its finito. Some of its core services will be ported into the nect generation CF

RE: Post-Spectra Content Management Systems??

This was posted by Charles Teague on the Spectra Forum. Hi everyone. We really appreciate everyone's patience over the last few weeks. There has been a lot of discussion and concern over the future of Spectra, and I think that the time is right to shed some light on what

Re: Post-Spectra Content Management Systems??

Macromedia has announced that Spectra 1.5 will be the last release to the product. They will continue to sell and support Spectra 1.5 for two years, and will then roll it over to a community supported product that I would suspect would be akin to how the Allaire's Forums product went. As for

RE: Post-Spectra Content Management Systems??

Thanks...I finally came across that email, but from what I could tell there was nothing on the Allaire/Macromedia site about it which seems a little odd to me. Chris -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:59 AM To: CF-Talk Subject:

RE: Post-Spectra Content Management Systems??

I saw a demo of commonspot and was very impressed with its functionality however the $$$ were pretty high. Rich -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 9:53 AM To: CF-Talk Subject: Re: Post-Spectra Content Management Systems??

database sorting

I have a conference database with a text field for time. The times are entered in 12 hour time with am or pm (ex., 9:00 am or 2:00 pm). Is there a way to sort this field to list the conferences in order by time? The problem I see, is 2 comes before 9, so the above example will list the 2:00 pm

RE: Post-Spectra Content Management Systems??

Although Spectra will be supported for the next 2 years, I'm sure as hell not going to sell it clients now - I'm simply looking for another solution. And it's probably only a 1-2 year solution as CF 6 will have Spectra's CODB etc built in. I'm gonna check out CommonSpot 2.0, or as Neil

CF component for secure FTP

Hi all, Does anyone know of CF component that will do secure FTP using SSH2? Thanks, Kay. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia

insert problem

i'm trying to same a number that has been formatted as dollar amount if i have an amount that is $1,110.00 it's telling that i have an error i'm pretty sure that it is because i'm trying to save and the number is being placed with a comma in it. how can i work around this. Error Diagnostic

CF dynamic pages for Search Engines

Could someone direct me to a source that describes how the major search engines handle dynamic pages, query strings,etc within a coldfusion site ? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: insert problem

can you post all the error code? Check the field to make sure you are able to use decimals for one. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 1:23 PM To: CF-Talk Subject: insert problem i'm trying to same a number that has been

RE: insert problem

Nope, no comma there, Incorrect syntax near '110.00'. would lead me to guess that you have INSERT INTO Table (Price) values ('#price#')... see if there are quotes around your field name and if there are, remove them. HTH Hatton -Original Message- From: Metzy Martinez [mailto:[EMAIL

RE: insert problem

Replace(1,110.00, ,, , ALL) or Replace(thevar, ,, , ALL) if it's in a variable. -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:23 AM To: CF-Talk Subject: insert problem i'm trying to same a number that has been formatted as dollar

RE: insert problem

what is the field type that is receiving the amount?if it's a charachter field then you are ok. If not then you will have to remove all comma before passing to the SQL string -- Andrew Ewings Project Manager Thoughtbubble Ltd

Update problem

I am showing information in columns. Each column represents a different quarter. We need the user to do an update every quarter. To achieve this look I used the code: CFOUTPUT QUERY=GetSubjects GROUP=SkillID TR TD COLSPAN=2#Skill#/TD CFOUTPUT TD CFIF

JS:URL Parameter in window.open

does anyone know something like this will work: window.open('file.cfm?name=value', ... ) (does not seem to be working.) is there another easy way to control window size while passing a parameter in the URL??? TNX if you can help. Rick Colman

RE: structure in request scope

A request scope variable must be re-set for each page load - that's how request variables work. You could do this cfquery name=request.colorscheme datasource= cachedwithin=some_time_period /cfquery which would run this query at the internal indicated by the cachedwithin attribute; if between

RE: Post-Spectra Content Management Systems??

I'm looking at eMPower by http://www.ektron.com/web-content-management-software.cfm to fill in some of the gaps. The are the guys that make the eWebEditPro HTML editor that's inside of Spectra. -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001

RE: Bit Masks

Bit masks are cool, but remember that there is a limit to how much info you can pack in a bitmask because CF doesn't let you use the bit functions on anything of more than 32 bits. I have taken to using lists for this sort of thing because there's no practical limit to how many items it can

RE: Update problem

Can you include the call to the GetSubjects query too... -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom

Re: structure in request scope

On 5/10/01 1:59 AM Mark Ireland wrote: Could someone tell me how to load a structure into the request scope in the application.cfm once only when a user first visits a page. That is, check that the structure is there and dont rerun the query code if it is unless a change has been made

Internal Server Error

We just set up a Windows 2000 Advanced Server with ColdFusion 4.5.1 SP2 and cannot get any cfm files to work, it always gives me an Error 500 - Internal Server Error. Does this for asp pages also. I did not set up the machine, so figure the guy that did messed with some setting to mess this up,

Download Software From The CF Server

What is the best way to set up a process so that clients can download software from the CF server? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Re: Post-Spectra Content Management Systems??

Ektron's eMPower is pretty slick, and uses the same WYSYIWYG as Spectra (Ektron's eWebEditPro) http://www.ektron.com -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Steve Vosloo wrote: I'm sure this has been discussed already, so apologies up front. We are a web co that has

RE: URL Parameter in window.open

That should work fine but if you intend to send through CF variables then you need to wrap it in a CFOUTPUT. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 15:40 To: CF-Talk Subject: JS:URL Parameter in window.open does anyone know something like

RE: insert problem

Please excuse my inaccurate response, I wasn't fully thinking... Hatton -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:30 AM To: CF-Talk Subject: RE: insert problem Nope, no comma there, Incorrect syntax near '110.00'.

RE: Internal Server Error

fdisk -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 15:55 To: CF-Talk Subject: Internal Server Error We just set up a Windows 2000 Advanced Server with ColdFusion 4.5.1 SP2 and cannot get any cfm files to work, it always gives me an

RE: insert problem

I tried doing a replace but i still get the same output I'm doing this before i save. my field type is money. there are no quotes on my field cfquery name=prodEdit datasource=#dsn.bps# dbtype=ODBC Update product Set sectionID = #sectionID#,

CFQUERY max. timeout?

Anybody know what the CFQUERY maximum timeout value is? It seems to be driver-dependent; we're running Oracle Native Drivers on CF 4.5. SP2. thanks, Chris Norloff from the online help: TIMEOUT Optional. Lets you specify a maximum number of milliseconds for the query to execute before

stored procedure problem

Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who

OT: Data Integrity - Q of the Day

Here's a question that's been bothersome for some time. We have an interface where participants register for meeting. There is a form they fill out with basic information, including the pharmaceutical company they are associated with. We use drop downs where we can to keep data as constant as

RE: Code Snippet:Random Password Generator(repost)

Why define the alphabet? Just use decimal values for the asci char set. Ok here's another code snippet, this is a password gen that I use now and then. The slight advantage of this one is it creates a word which hopefully more rememberable than just random letters and numbers. There's more

RE: URL Parameter in window.open

oh! oh! I know the answer to this one! :) I did this already..hang on lemme get the code here.. ok! Go to www.opentelecom.com and click Send E page. and do a View Source on that page ^_^ Its all there. But just in case the site is down or somethign here is the relevant code: function

RE: stored procedure problem

do the same thing... use [brackets ] ~Simon Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Greg Jordan [mailto:[EMAIL

RE: stored procedure problem

you should be able to do the same thing. It's not the VB that interprets the brackets it's the SQL itself. I assume you are passing in a field list into a SP as a param so you know what fields to update?just put brackets around the field names. A P.S. shoot your DBA..before he goes

RE: insert problem

I've had problems with using money fields in the past. In fact the last place I worked the DBA's would not allow any fileds of type money at all. Can you get away with using an integer field? Jusat a poinbt to note - you are removing the commas before inserting but are you removing the $'s too?

Re: Internal Server Error

Internal server error sometimes means that the permissions are messed up. Try allowing everyone full access to the page, and try again, then work backwards and see how high you can set the permissions and still have it work.. Does anyone know what permissions have to be set for cf to

RE: stored procedure problem

Rename the column in your query as so: SELECT A OR B as A_OR_B Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:44 AM To: CF-Talk Subject: stored procedure

RE: Bit Masks

Thanks for the list tip! I'm just now developing an application using CF's BitAnd() function. In my application, I currently have the following permission levels: Level UserDescription Permission DB value for BitAnd 1 1

RE: Code Snippet:Random Password Generator(repost)

What if it randomly generates a bad word? Erika (with a *K*) -Original Message- From: Daniel Kemp [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:42 AM To: CF-Talk Subject: RE: Code Snippet:Random Password Generator(repost) Why define the alphabet? Just use decimal values

RE: insert problem

no no. don't put quotes around price in the Replace function. :) use #Replace(price, ,, , ALL)# not #Replace(price, ,, , ALL)# -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:33 AM To: CF-Talk Subject: RE: insert problem I tried

Re: SQL 7 Question

I set SET NOCOUNT ON/OFF outside the BEGIN/COMMIT TRANSACTION and it seems to work fine. Thanks! best, paul At 10:54 AM 5/10/01 +0700, you wrote: * Team Allaire * Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT

RE: insert problem

when saving dollar amounts, I always use: REReplace('#thelist#', '[^0-9.]', '', 'ALL' ), and then dollarformat() or lscurrencyformat() when I display. HTH D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering.

RE: Data Integrity - Q of the Day

We had a similar issue with the City field in a database. We maintain a City table, and each user record only contains the primary key (an integer id) to the corresponding record in the City table. For the user interface we created a combo-type box, so that a user could either select their City

OT: WingDings

Hi, Using CF_HTMLMenu and was looking for a good reference on the ASCII translation of the WingDing character set. Those I've found on the web don't seem to be current or complete. Any ideas on where I can find one? Thanks, Andrew ~~ Structure

Re: insert problem

No quotes around salePrice: #Replace(salePrice, ,, , ALL)# (But why isn't numberFormat working for you ) - Original Message - From: Metzy Martinez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 2:32 PM Subject: RE: insert problem I tried doing a

Re: Data Integrity - Q of the Day

Unless you've got a table of distinct companies for registrants to choose from, you've got to solve the problem in the search application. Using a drop down list here, when you know there could be multiple spellings of a company, is probably the wrong approach. It depends a little on how exact

OT: XML and Java training?

My boss and I are being asked by hq to get training in XML and Java. Can anybody in this multi-disciplinary group of wizards recommend a training source? (We're in the San Francisco Bay Area.) Thanks! Ben Braver Information Technology Ultramar Inc. Golden Eagle Refinery 150 Solano Way

RE: Internal Server Error

There is 4.0x info here: http://www.defusion.com/articles/index.cfm?ArticleID=89 if you have corrections/updates to offer I'd love to see them. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:08 PM To: CF-Talk Subject: Re: Internal

RE: cfloop vs cfoutput

Thanks for clearing that up for me KOla -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 12:03 To: CF-Talk Subject: RE: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which

RE: Bit Masks

Well, you're not limited to 5 levels, but rather 31; if you feel confident that will be enough then you're set. Your second approach works IF you can always assume that all the security levels are either lesser or greater than the new one you want to add, never equal. But if you need to have

SQL7008N REXX variable (Again)

DB2 Error Code = -7008 [IBM][CLI Driver][AS] SQL7008N REXX variable SUBMI1 contains inconsistent data. SQLSTATE=55019 This error only occurs on production side. Back-end is the same for local and production development. Using AS/400 on IBM mainframe. Prod box is Unix, local is Win2k. Last

RE: Code Snippet:Random Password Generator(repost)

Seems unlikely, but it does generate some great words like teethuku and taafduno and the unforgettable fuoflyru. Fun script. -Original Message- From: Erika L Walker [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:19 PM To: CF-Talk Subject: RE: Code Snippet:Random

RE: Data Integrity - Q of the Day

Yep we had an identical thing where students had to select a school that they attended in the UK from the complete list of schools (a lot!). We got around it asking the user to enter the first three letters of there school - we then present them with the form with a reduced list of schools

RE: WingDings

Roll your own: cfoutput cfloop index=i from=0 to=255 #i# - span style=font-family: wingdings#chr(i)#/spanbr /cfloop /cfoutput -Original Message- From: Andrew Peterson [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:35 PM To: CF-Talk Subject: OT: WingDings

CF and custom stylesheets

Hey gang... I've kinda got this working, but would prefer to improve it a bit. I'm trying to modify an existing app, that uses stylesheets, to allow for customization of the colorsets... so that User #1 can choose the blue set, User #2 the green set, etc. Each set has a hex color code for each

RE: stored procedure problem

Simon would you use brackets in the output when ref. the field or in the SQL? Greg -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:09 AM To: CF-Talk Subject: RE: stored procedure problem do the same thing... use [brackets ] ~Simon

Crystal Reports rehash

I hate to rehash this, but I have gone through the archives and cannot find what I need. I am trying to pass parameters to a crystal report, example - last name: if the HTML for last name is left blank I don't wantit as part of the crystal filter, if someone put something in the fieldI want

Re: [OT: XML and Java training?]

U of Hawaii for a few weeks. Braver, Ben [EMAIL PROTECTED] wrote: My boss and I are being asked by hq to get training in XML and Java. Can anybody in this multi-disciplinary group of wizards recommend a training source? (We're in the San Francisco Bay Area.) Thanks! Ben Braver Information

RE: Update problem

Here's my GetSubjects query. It comes from another page and in called by a CFINCLUDE tag. CFQUERY NAME=GetSubjects DATASOURCE=#Request.maindsn# SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject,

RE: insert problem

Thank you guys for all your help i'm thinking it didn't like the comma because it thought it was a function of sql i'm such a dork i put quotes on the price, it work with out the quotes, he he. but even after that it still didn't change my variable, so i thought about cfset variable =

RE: Bit Masks

I believe that someone once gave a presentation at one of the CFUGs about using bit masks, also know as Right Bit AND, to set up security access levels. This wasn't the same as the presentation at the Fig Leaf site that's slight more oriented towards hierarchy uses. I've looked at all the

Resturant/Golf reservation system

Has anyone out there created a reservation system for either a resturant or a golf course? I am looking to see if there is anything out there that already exists so that I do not have to re invent the wheel for this. Thank you Alan ~~

RE: Bit Masks

I understand the 31, but it's 5 levels not 31 with the constraint I described below. But your point is well-taken. I guess I should look for where issues similar to the ones you raise might arise. On the accounting/construction issue you raise, I have a similar one I didn't mention. Project

Contracts invoice forms for freelance?

does any one have a basic formal agreement docs, or contracts i could modify for a freelance job? a formal contract which outlines your fees, returns of content and information if we part company, termination of agreement, turn around time, ect. also if you have a Monthly invoice with a work

Hosting /Dedicated or else

Looking for recommendations on CF Hosting places. No cheap places, places that kick butt! Christopher Badouin - founder www.giveitaudio.com -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:51 AM To: CF-Talk Subject: RE: URL Parameter in

Re: WingDings

Used to be little Windows Accessory - CHARMAP.EXE. You should be able to find a copy somewhere, it works great for me. - Original Message - From: Andrew Peterson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 12:35 PM Subject: OT: WingDings Hi, Using

  1   2   >