RDS through CFStudio

2001-05-10 Thread Cameron
Well, this is probably an old topic, but I can't seem to get RDS working though Coldfusion Studio. I've set up the CF Server to have a password for Studio access (Basic Security, Advanced not installed). Creating a RDS server in CF Studio doesn't allow me to connect... nothing I do works... I

Re: Putting a period after the TLD in a URL

2001-05-10 Thread Judith Taylor
Simple, your web page was hacked by the Chinese hackers... Guess you fell victim to the worm that's been going around exploiting that 7 month old security hole in IIS. Judith Scott Wolf put into words: >Everyone, > > >I'm working on a site and when I enter the URL with an extra . at the end of

RE: SQL7008N REXX variable (Again)

2001-05-10 Thread David Shadovitz
Don't know whether this helps, but a web search turned up: SQL 7008N REXX variable "" contains inconsistent data. Explanation: A variable that contained inconsistent data was passed to REXX. The command cannot be processed User Response: If the variable is an SQLDA, verify that the data and lengt

Session variable

2001-05-10 Thread Michael S. Kimmett
I am trying to debug a website that is using Session variables. The problem is I have one account that is not getting to log on to the website because the session variable that are sent to the DB are not in the DB. However, all the other accounts that are using this same website are allowed t

Re: [Re: Native Drivers - Oracle80]

2001-05-10 Thread Julia Phu
"... you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also" Yes, I had Oracle 8 client software installed and have created a service name, ABC. On the CF Settings page: DSN: ABC Host String: 127.0.0.1:1521 C

RE: searching date ranges

2001-05-10 Thread John
It would help to know what database it was so the functions could be more specific. Select * from table where facility = 'Atlanta' and ** this will depend on if you mean null or blank length function like len(audit_date) = 0 or audit_date is null and **then use a date function to subtract 90 days

RE: database sorting

2001-05-10 Thread Chris Montgomery
Tim, I have a page that lists job fairs with starting & end times (using the 12 hour format). A simple query does it for me: SELECT * FROMJobfairs WHERE EvtDate >= Now() -1 ORDER BY EvtDate, StartTime1, EndTime1 Chris Montgomery [EMAIL PROTECTED] Web Development & C

RE: searching date ranges

2001-05-10 Thread Garza, Jeff
Try SELECT facility from YourTable WHERE audit_date = NULL AND rcvd_date < #CreateODBCDateTime(DateAdd("d", "-90", now()))# You may have to tweak the date format (if you're not using ODBC...). FYI -- this is untested code... Jeff -Original Message- From: Tim To: CF-Talk Sent: 5/10/

RE: CFHTTP and port numbers

2001-05-10 Thread Garza, Jeff
Nick, This might sound rather simple, but are you using the port attribute of CFHTTP or typing it into the address line? http://foo.bar.com"; method="GET" port="6660" resolveurl="true"> I don't think that http://foo.bar.com:6660 will work in the address line. Jeff ---

CFHTTP and port numbers

2001-05-10 Thread DeVoil, Nick
It seems that CFHTTP cannot connect to an address of the form http://foo.bar.com:6660 Can anyone confirm this and/or tell me how I can make an HTTP request to an address like this? Thanks Nick ** Information in this email is

searching date ranges

2001-05-10 Thread Tim
I have a database with fields called facility, rcvd_date and audit_date. I need to query the database for a user selected facility with a rcvd_date that is greater than 90 days old and the audit_date field is blank. For instance, the user selects Atlanta, and the query will return all records fo

Ftp To Novell

2001-05-10 Thread Joshua Tipton
I am trying to ftp to a novell server and am not having the best of luck. I can get the currect directroy to return sys: which is right. When I try to listdir of a direcotyr called crsapps I get nothing. I have tried /crsapps, crsapps. crsapps/*.* and get nothing. Is there a trick to novell?

Putting a period after the TLD in a URL

2001-05-10 Thread Scott Wolf
Everyone, I'm working on a site and when I enter the URL with an extra . at the end of it, I get sent to a COMPLETELY different page. I was wondering if anyone could possibly tell me where this is coming from. I would really appreciate any help you could offer. Thanks in advance. Normal

Re: Uploading 2 5-10 K Files

2001-05-10 Thread Tom Davison
and upload... take a look at them - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 7:19 PM Subject: Uploading 2 5-10 K Files > I want to upload 2 files at a time that are five to 10 K. I already have > written some C++ code t

Uploading 2 5-10 K Files

2001-05-10 Thread jeffwilliamstevens
I want to upload 2 files at a time that are five to 10 K. I already have written some C++ code to post data like a form to a CF processing page. Is it possible to just URLencode each byte and assign it to FORM variables for CF to reassemble? Is there an easier way to upload files? I have written

Re: Hosting /Dedicated or else

2001-05-10 Thread Pablo Varando
We accomodate Dedicated CF Servers from $300 a month :) http://www.cfm-resources.com Pablo - Original Message - From: Chris Badouin <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 2:22 PM Subject: Hosting /Dedicated or else > > Looking for recommendatio

RE: Running DTS in Stored rocedure

2001-05-10 Thread David Sterling
Im running SQL 7.0 on an NT4. -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 3:53 PM To: CF-Talk Subject: RE: Running DTS in Stored rocedure What version of SQL server are you running? I just had to set something like this up on SQL2

RE: CF and custom style sheets

2001-05-10 Thread Eric Gilbert
It's pretty a straight forward solution. 1) The code to call the included stylesheet could look something like this regular old html3.2 except for .cfm so that the requested file gets parsed by cf 2) In stylesheet.cfm h1 {

New "Allaire Alive" titles available

2001-05-10 Thread Peter Tilbrook
http://www.allaire.com/allairealive/index.cfm Peter Tilbrook Chief Web Developer Lunar Power Internet Technologies Unit 1, 26-28 Winchcombe Court Mitchell, ACT, 2911 AUSTRALIA Phone: +61 2 6242 Fax: +61 2 6242 6655 WWW: http://www.lunarpower.com.au ~~~

Re: Native Drivers - Oracle80

2001-05-10 Thread Tom Davison
did you install the oracle 8 client software on the server? when you do you must give it a service name remember that because you will have to use this when creating the dsn and you will need rights to the db also. - Original Message - From: "Julia Phu" <[EMAIL PROTECTED]> To: "CF-Talk" <

RE: Hosting /Dedicated or else

2001-05-10 Thread robrusher
I have used and recommended Flare Networks to many companies and developers. http://www.flarenetworks.com/ >From developer accounts to hosting for HP. I've even had people thank me for the recommendation. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certi

Re: 1s and 01s

2001-05-10 Thread Kevin Miller
Use the VAL function on the 01 value so that 1 = 1. Kevin >>> [EMAIL PROTECTED] 05/10/01 01:56PM >>> Hello, i'm passing a number from a form and then comparing it with a number pulled out of the DB (SQL server) but when i do the comparison it's against 1 (passed by the form) and 01 (passed by SQ

RE: Post-Spectra Content Management Systems??

2001-05-10 Thread robrusher
I don't know much about it, but I know a guy who made www.webonthefly.com. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certified Java Programmer email: [EMAIL PROTECTED] phone: 303-885-7044 plan, build and integrate interactiv

Client Variable and Internet Caching options

2001-05-10 Thread Brook Davies
We have a cf app which uses client vars and at various parts of the application, on pages which displays some info from a client var, the info being displayed was from old client variables which were no longer being used. We could not figure out why this old data was popping up. Client vars are

Re: 1s and 01s

2001-05-10 Thread Scott Weikert
Do you REALLY need it to be "01"? Or are you comparing numerical values? You can just use the Int() function on both values... like Though as long as you use "EQ" instead of "IS" (which is used to compare STRINGS), you shouldn't need the Int() function at all... - Original Message - Fr

RE: 1s and 01s

2001-05-10 Thread Steve Bernard
Use NumberFormat() or compare them as numbers, not text. Steve -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 4:56 PM To: CF-Talk Subject: 1s and 01s Hello, i'm passing a number from a form and then comparing it with a number pulled out of

Re: CF & Flash (detection)

2001-05-10 Thread John Dowdell
At 4:50 PM 5/8/1, Chris Badouin wrote: > Does anyone use a CF to detect flash installed on users browser? I might suggest a difference approach, because there has been a shift recently... it's now usually more valuable to detect the level of the visitor's SWF capabilities, rather than just whethe

RE: Hosting /Dedicated or else

2001-05-10 Thread Kelly Matthews
www.knrtech.com -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 3:25 PM To: CF-Talk Subject: RE: Hosting /Dedicated or else cfdynamics.com ROCKS!! ~Simon Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Lea

Re: [OT: XML and Java training?]

2001-05-10 Thread Billy Cravens
Productivity Point is pretty good: www.propoint.com -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Alex wrote: > 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 th

Native Drivers - Oracle80

2001-05-10 Thread Julia Phu
Greetings, Does anyone have any suggestion about setting up a DSN with Oracle80 native drivers? Or any sources to lookup? Here is my problem. Oracle8i and CF Application Server 4.5 Enterprise Edition installed on NT 4.0 server with sp6a. When I run the verify, I got the following message. * Ar

RE: Running DTS in from CFCOMET COM OBJECT

2001-05-10 Thread David Sterling
I am having problems running a DTS package using the COM object from CFCOMET... I keep getting this error: No Steps have been defined for the transformation Package. The error occurred while processing an element with a general identifie

RE: Outputting Raw CFML

2001-05-10 Thread Raymond B.
Lots of ways, a quick fix is to run it through htmlCodeFormat() or just enclose it in tags. -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: May 10, 2001 12:18 To: CF-Talk Subject: Outputting Raw CFML I want to build an app that will traverse our directories and

RE: using WDDX for next 'n' style browsing

2001-05-10 Thread Craig Bowes
Yes, and that is something to consider. But say a recordset has about 1000 records. A 1000 records of text isn't that much memory. And you could set the timeout so the session variable dies after a short while thus freeing memory that way. -Original Message- From: Kola Oyedeji [mailto:

1s and 01s

2001-05-10 Thread David Baskin
Hello, i'm passing a number from a form and then comparing it with a number pulled out of the DB (SQL server) but when i do the comparison it's against 1 (passed by the form) and 01 (passed by SQL). Can anyone tell me how to format the number coming from the form and CF to pass or be written as 01

RE: Running DTS in Stored rocedure

2001-05-10 Thread Bob Silverberg
What version of SQL server are you running? I just had to set something like this up on SQL2000, and there are a few pointers I can give you. Also, which password are you referring to? The user login password, the package password, etc? Thanks, Bob -Original Message- From: David Sterl

enabling browser for java

2001-05-10 Thread andrew kopelman
I am getting an error, while trying to run cftree: Browser must support Java to view Cold Fusion Java Applets! I've got the browser's (advanced internet) options for java console enabled and java logging enabled and JIT compiler for virtual machine enabled. Is there anything else that might be

Re: CF and custom style sheets

2001-05-10 Thread Scott Weikert
I think this is the route I'll need to take... just a matter of building a page that, when I update my colors for a set, it puts all the style code into a big text var and writes out the file... grumble... not the route I wanted to take, but oh well. Thanks guys :) --Scott - Original Message

RE: Outputting Raw CFML

2001-05-10 Thread Greg Jordan
CF_FileWriteText could most likely do the trick or use the Replace Function using < for < and > for > Greg -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 2:18 PM To: CF-Talk Subject: Outputting Raw CFML I want to build an app that will

Re: New Cold Fusion book, O'riely Press

2001-05-10 Thread Michael Dinowitz
* Team Allaire * Knowing all the work Rob is doing on UDF, I'm betting it's a 5.0 book. > Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 > is released? > > On Thu, 10 May 2001, DeVoil, Nick wrote: > > > Jeff, > >

RE: New Cold Fusion book, O'riely Press

2001-05-10 Thread Aaron Rouse
Isn't the O'Reilly book over CF 4.5 and going to be released after CF 5.0 is released? On Thu, 10 May 2001, DeVoil, Nick wrote: > Jeff, > > I agree that O'Reilly books are usually excellent. > I don't know anything about this one. > > But you might like to know that Wrox are also > bringing

RE: Outputting Raw CFML

2001-05-10 Thread Kurt Ward
#Doh# -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 3:18 PM To: CF-Talk Subject: Outputting Raw CFML I want to build an app that will traverse our directories and extract the text within ColdFusion comments. I will use this to build a

Re: Contracts & invoice forms for freelance?

2001-05-10 Thread Billy Cravens
I'd highly recommend paying a lawyer to draft a "template" up for you. Free templates are cool, but the whole purpose of a legal document is that it covers your arse, and due to differences in localities, only a lawyer can ensure there's no loopholes. For invoicing, I like QuickBooks. -- Bill

Re: Hosting /Dedicated or else

2001-05-10 Thread Billy Cravens
Buy your own server, set it up, send it to colo. If you can afford it, the only way to go, unless you're willing to share resources with 200-300 other websites. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Chris Badouin wrote: > Looking for recommendations on CF Hosting places

Re: Download Software From The CF Server

2001-05-10 Thread Billy Cravens
If you want direct download, point to the exe. If you want control over who can get to it, use CFLocation. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Jerre Hale wrote: > What is the best way to set up a process so that clients can download > software from the CF server? > >

Re: Bit Masks

2001-05-10 Thread Ken Monroe
That's the one! Thx much and Thanks! to Cameron Childress for his presentation also. - Original Message - From: "Aaron Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 3:03 PM Subject: RE: Bit Masks > hey guys, > > The presentation you're look

problem with cftree

2001-05-10 Thread andrew kopelman
I am just trying to get the cftree example in the studio help to work. While I do not get any error (and the top half of the page with the cfselect does work), where the applet is supposed to show up, I just get a grey rectangle. Any reason(s) this might be happening? I am at a loss. Thanks

RE: CF and custom stylesheets

2001-05-10 Thread Semrau, Steven L Mr SRA
I'm assuming in the style.cfm you have present? Thus the reason it works when you the page. Remove the tags, and rename the page to style.css Then: change to That should do it. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [E

RE: Contracts & invoice forms for freelance?

2001-05-10 Thread Greg Jordan
Paul This subject may be better suited for the CFCommunity List, but...my advice is make sure that EXPLICITLY define what you are and are not going to do. if you leave that open on any point, you could find yourself doing more than you bargained. It is well worth it to nail that down before doing

RE: WingDings

2001-05-10 Thread Semrau, Steven L Mr SRA
If you have Character Map listed in your accessories (windows - start/programs/accessories/); start it up, change Font to Wingdings, select a wingding you are looking for from the listing that displays, in the bottom right corner of the applet it shows the keystrokes for the character you click

Re: Contracts & invoice forms for freelance?

2001-05-10 Thread Jeffry Houser
;) Get a lawyer. There is a good chance that my needs will not fit your needs (and vice versa). At 02:12 PM 05/10/2001 -0400, you wrote: >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, ret

RE: stored procedure problem

2001-05-10 Thread Greg Jordan
FYI if you find any forbidden characters in your db fieldnames, such as spaces, using CF_RenameQueryColumns works, as does wrapping your field names with brackets in your SQL statement (as many devs suggested and, in many cases, easier) like this: Select [BAD FORMAT], [BILL GATES] FROM Table

Re: XML and Java training?

2001-05-10 Thread Jon Hall
Sun does training. http://suned.sun.com/HQ/developers/ jon - Original Message - From: "Braver, Ben" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 12:47 PM Subject: OT: XML and Java training? > My boss and I are being asked by hq to get training in X

RE: Hosting /Dedicated or else

2001-05-10 Thread Robert J. Bailey
check out carolina.net, I have used them for some time, fast servers, support CF and ASP, get an SQL server with unlimited space, no bandwidth restrictions, love them Also one I like is advances.net Take a look Robert J. Bailey (646) 526-4536 -Original Message- From: Chris Badouin [ma

RE: Contracts & invoice forms for freelance?

2001-05-10 Thread Robert J. Bailey
Check out Invoice2000, I use that to keep my invoices and to print them, it is also free from www.download.com As for my contract, I got a copy of it at home that I will have to remember to bring if you want to see mine Robert J. Bailey (646) 526-4536 -Original Message- From: Paul Ihrig

RE: Resturant/Golf reservation system

2001-05-10 Thread Robert J. Bailey
I have created one for a hair salon, used an SQL server and cold fusion for the web, a simple Access application that connected to the SQL server for their offices Robert J. Bailey (646) 526-4536 -Original Message- From: Alan Koenig [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 200

Re: New Cold Fusion book, O'riely Press

2001-05-10 Thread Michael Dinowitz
* Team Allaire * I know Rob and I've seen some of the pre-release of the book. It'll be great. > Jeff, > > I agree that O'Reilly books are usually excellent. > I don't know anything about this one. > > But you might like to know that Wrox a

RE: Hosting /Dedicated or else

2001-05-10 Thread Simon Horwith
cfdynamics.com ROCKS!! ~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: Chris Badouin [mailto:[EMAIL PROTECTED]] Sent: Th

Running DTS in Stored rocedure

2001-05-10 Thread David Sterling
I am having problems running a DTS package from a stored procedure... Here is my code: CREATE PROCEDURE [run_TestDTS] AS Exec MASTER..xp_CmdShell 'dtsrun /sql01/testun/testpass/testDTS'

Outputting Raw CFML

2001-05-10 Thread Kuehn, Matthew
I want to build an app that will traverse our directories and extract the text within ColdFusion comments. I will use this to build a kind of dynamic help generator. I'm trying to use cffile to read in the file so that I can use Find() to look for the commented code. But, if I read in the file an

RE: Bit Masks

2001-05-10 Thread Cameron Childress
Hey hey! Looks like I'm not the only one. I think I knew about this presentation at one time actually... Focuses lots more on bits than mine did... -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: Aaron Johns

RE: New Cold Fusion book, O'riely Press

2001-05-10 Thread DeVoil, Nick
Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2&isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mai

RE: Bit Masks

2001-05-10 Thread Aaron Johnson
hey guys, The presentation you're looking for was at the Arizona CFUG, which isn't coming up right now... *but* with the wonders of Googles cache you can get the article: http://www.google.com/search?q=cache:www.azcfug.org/technotes/index.cfm%3Ffu seaction%3Dadvancedcode%26technote%3Dbitmask+Col

RE: Crystal Reports rehash

2001-05-10 Thread Braver, Ben
j p Here's the CF side of one that works: It's printing a report for a particular Unit and specific range of dates selected on a form. Substitute the name of your Crystal Report file for "crname.rpt". {OracleViewName.UNIT_ID}="#UnitID#" AND {OracleVi

Re: JS:URL Parameter in window.open

2001-05-10 Thread Bryan LaPlante
Try building your string first and then pass it to window.open() in a variable. - Original Message - From: "Richard Colman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 9:40 AM Subject: JS:URL Parameter in window.open > > does anyone know something

RE:OT: URL Parameter in window.open

2001-05-10 Thread Semrau, Steven L Mr SRA
Not exactly sure what you are asking without seeing more of the code or error that you have... does the window.open() work? OR Is there an easy way to control window size? If you are using any variables within the window.open function make sure to wrap around the script/function so the variab

RE: CF and custom stylesheets

2001-05-10 Thread Robert J. Bailey
I have done this by replacing the style.css with a variable. I grabbed what the users preferences was via a cookie or the database, and then used that to decide what style sheet to include. Robert J. Bailey (646) 526-4536 -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]]

Re: CF and custom style sheets

2001-05-10 Thread Sean Daniels
On 5/10/01 1:27 PM Scott Weikert wrote: > > > I've had some hassles trying to link the page like this... it doesn't seem > to properly execute the CF code within. > > Anyone out there tried to do this same thing, and succeeded? Input would be > most welcome. Two suggestions: 1. Make a new st

Re: CF and custom stylesheets

2001-05-10 Thread Dave f
I've tried the same thing and also failed! There *ARE* differences in the way that INCLUDED'd and SRC= stylesheets work. I never figured out how or why. - Original Message - From: "Scott Weikert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 1:27 PM Su

Re: WingDings

2001-05-10 Thread Dave f
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, >

Hosting /Dedicated or else

2001-05-10 Thread Chris Badouin
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

Contracts & invoice forms for freelance?

2001-05-10 Thread Paul Ihrig
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 d

RE: Bit Masks

2001-05-10 Thread Paul Smith
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

Resturant/Golf reservation system

2001-05-10 Thread Alan Koenig
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 ~~ Structure

RE: Bit Masks

2001-05-10 Thread Cameron Childress
> 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

RE: insert problem

2001-05-10 Thread Metzy Martinez
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 i didn't have to replace

RE: Update problem

2001-05-10 Thread Janine Jakim
Here's my GetSubjects query. It comes from another page and in called by a CFINCLUDE tag. SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID, tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject, tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor, tbl_StudentGrade.Gradi

Re: [OT: XML and Java training?]

2001-05-10 Thread Alex
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

Crystal Reports rehash

2001-05-10 Thread j p
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 to

RE: stored procedure problem

2001-05-10 Thread Greg Jordan
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 Si

CF and custom stylesheets

2001-05-10 Thread Scott Weikert
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 eac

RE: WingDings

2001-05-10 Thread Howarth, Craig (IBK-NY)
Roll your own: #i# - #chr(i)# > -Original Message- > From: Andrew Peterson [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 10, 2001 12:35 PM > To: CF-Talk > Subject: OT: WingDings > > Hi, > > Using CF_HTMLMenu and was looking for a good reference on the ASCII > transl

RE: Data Integrity - Q of the Day

2001-05-10 Thread Andy Ewings
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 begini

RE: Code Snippet:Random Password Generator(repost)

2001-05-10 Thread Howarth, Craig (IBK-NY)
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 Snippe

SQL7008N REXX variable (Again)

2001-05-10 Thread James Taavon
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. Las

RE: Bit Masks

2001-05-10 Thread mherbene
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 t

RE: cfloop vs cfoutput

2001-05-10 Thread Kola Oyedeji
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: Internal Server Error

2001-05-10 Thread mherbene
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 Ser

OT: XML and Java training?

2001-05-10 Thread Braver, Ben
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 Martinez,

Re: Data Integrity - Q of the Day

2001-05-10 Thread Jim McAtee
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 t

Re: insert problem

2001-05-10 Thread Dave f
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 trie

OT: WingDings

2001-05-10 Thread Andrew Peterson
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 yo

RE: Data Integrity - Q of the Day

2001-05-10 Thread Bob Silverberg
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

RE: insert problem

2001-05-10 Thread Diana Nichols
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." ---Laza

Re: SQL 7 Question

2001-05-10 Thread Paul Smith
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

2001-05-10 Thread Dylan Bromby
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

RE: Code Snippet:Random Password Generator(repost)

2001-05-10 Thread Erika L Walker
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 value

RE: Bit Masks

2001-05-10 Thread Paul Smith
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 Public

RE: stored procedure problem

2001-05-10 Thread Larry Juncker
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 pro

Re: Internal Server Error

2001-05-10 Thread Al Musella, DPM
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 wo

RE: insert problem

2001-05-10 Thread Andy Ewings
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?

  1   2   >