RE: SQL quicky

Yeah I figured out the character part when I was reading sql healp. Guess when I import the data I'll need to automatically convert it from numericjust another thing to remember to do. -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001

OT:SQL quicky

How do I format a phone number (###) ###- within my cf sql statement? My backend is sql 2000. Thanks in advance. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.

RE: SQL quicky

, October 03, 2001 8:29 AM To: CF-Talk Subject: RE: SQL quicky Only accepting American phone numbers huh? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 10:21 PM To: CF-Talk

RE: SQL quicky

That's what I had originally. It works fine for my forms that pull up individual records. However, upon doing the bulk records I needed to change how my queries sat. All the related queries are a CFLOOP QUERY within a query.( CFQUERY MAINCFLOOP QUERY1CFLOOP QUERY2CFLOOP QUERY3 /CFQUERY) And for

weird format drop

I have a form that formats the phone/fax number. CFSET TELEPHONE=(#left(SchoolInfo.TELEPHONE,3)#) #mid(SchoolInfo.TELEPHONE,4,3)#-#mid(SchoolInfo.TELEPHONE,7,4)# Works fine when used in a regular query. Now I have changed the queries around so that I can do bulk printing so instead of: query1

RE: CF_ThreeSelectsRelated

Hi, The attachment didn't come through the list. (I'm not sure cftalk allows them). Anyways will you send it to me directly. I just posted to the forum some issues I was having with this tag and am wondering if the updated one would help. My problems were: 1. Is there a way to display more then 1

RE: CF_ThreeSelectsRelated

thing is that when passed it will be passed together. Joshua Tipton -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 1:26 PM To: CF-Talk Subject: RE: CF_ThreeSelectsRelated Hi, The attachment didn't come through the list. (I'm not sure cftalk

cf to excel display issue

I have set up an excel sheet to show results of a search. I also want to add another search- when the field is null or X. The query works, however, it does not show up correctly on the excel sheet. 1. The excel sheet does not line the nulls under the correct headings. No matter where on the

Double back button

I have a page that calls a pdf file. When a user hits the back button they are returned to the action page which of course sends them back to the pdf. If they click twice quickly they are returned to the original screen. It works, but feels clumsy. Is there some way I can make it that if the

Order by....

I have several queries that make a pdf output and am having some problems getting the order that I want to output. I need for it to output by teacher then student. The problem is my main query for this is the student query and there's no link to the teacher in that query. How I have it set up:

RE: Order by....

Thanks, that's what I figured I'd have to do Yes there is a link-but it you have to use a couple talbes(reference, etc). I just meant no direct link in student table. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:22 AM

help with selectthreerelated

I'm using the custom tag CF_ThreeSelectsRelated and can't get it to work completely. I can get the first two to drill down, but when I code in for the 3rd box I get no results... the form comes up with all the labels etc, but no data. Sooo somehow I am not properly passing the variableor

RE: help with selectthreerelated

quote (') or period (.). I ran into the same problem filling it with country, state, city. A number of cities had one or the other, as soon as I removed all quotes and periods, problem solved. Christian -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday

Format Tables (Was RE: CF to excel)

that you have built will come across as an excel file. The key is in the cfcontent tag and cfheader tag. John Anderson aloha-webdesign.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:40 PM To: CF-Talk Subject: CF to excel How flexible

RE: Format Tables (Was RE: CF to excel)

-Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:38 AM To: CF-Talk Subject: Re: Format Tables (Was RE: CF to excel) Can you show us the looping code? It's probably an error in reusing too much of the sample code --- Janine Jakim [EMAIL

CF to excel

How flexible is the process of generating excel files? I need to have an output that is dynamic for the columns and rows. For example: #student# #student# #student# #student# #Skill# #grade# #grade# #grade# #grade# #Skill# #grade# #grade# #grade# #grade#

CFOUTPUT Challenge

I have what I consider an interesting problem. I need to send the results of 6 queries out to make one form. (report/pdf style). My main query- person demographic query works great and opens up the correct number of reports (1 report per person). However, the other 5 queries only give the

RE: CFOUTPUT Challenge

#3.Order1# #Order2# /CFLOOP /CFOUTPUT Or it sounds like you possibly could join all 6 tables in a query. Let me know if the looping way works. Greg Luce 954-763-4504 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 8:41 AM To: CF

VBS to CF

I'm looking at some vbs code and want to convert it to CF. I have most of it, however, am not quite sure about one spot. They use the line of code: Set orr=DBConnect.Execute(strSQL) DBConnect had been set to Creat connection to DB strSQL is the name of the query that they wrote. That makes

OT: Multiple pdfs....

I have 2 problems trying to use ActivePDF- can anyone help? 1. I have a button that pulls up a single pdf report card. I now need to make it so that multiple (ie: whole grade) report cards can be printed out. I was told that I had to use the tag CFSET aptoolkit.FormNumbering=1 But that just: A.

Problem starting page with msg

Ok I am hoping to make this clear. I have a page that uses 2 tables for display. This table is set in an index page, not on the actual display page. The one column lists all the options (which homeroom student to change grades for) and the 2nd one shows the grades that can be changed. It works

OT: quick ActivePDF ?

Hey can someone tell me the command that will allow me to print out more then one form of the activepdf. My query-tested separately- shows all 40 chosen people that I want to print info for-1 or2 pags per person. However, when I do the activepdf it shows only the 1st person. 1. What command

RE: Quick format question

- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:04 PM To: CF-Talk Subject: Quick format question How do format for phone numbers I want it to print out like: (===) ===- I didn't see it in the CF books. thanks, j

RE: adding counts

I'm using sql2000. Thanks for getting me started-looks like I can go from here. j -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:26 AM To: CF-Talk Subject: Re: adding counts If you're using oracle, you could so something like

Quick format question

How do format for phone numbers I want it to print out like: (===) ===- I didn't see it in the CF books. thanks, j ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

RE: adding counts

distinguish absent from tardy from excused from unexcused? Where in the table is it located and how is the information represented? --- Janine Jakim [EMAIL PROTECTED] wrote: I've got a query that counts how many times a student is absent/tardy. It outputs fine BUT i need it to do things

adding counts

I've got a query that counts how many times a student is absent/tardy. It outputs fine BUT i need it to do things slightly differently- I need to combine a couple of the codes to make a total (For example 3 Excused +2 Unexcused= 5 absences). What is the best way to do this? CFQUERY

RE: Ot: sending pdf to the browser

] Subject: Re: Ot: sending pdf to the browser Date: Sun, 26 Aug 2001 19:59:38 +0200 Janine Jakim wrote: I have a cold fusion page that I use to populate a pdf. On the macs it downloads to the desktop first, then when clicked it opens in the browser. I need for it to just open in the browser

RE: Ot: sending pdf to the browser

that opens inside a brower window. Steve - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:13 AM Subject: RE: Ot: sending pdf to the browser No I would try one then the other Thanks for all the help. I finally got it so

Client variables

I have my pages set up with client variables. I need to change my main client variable. When I change my queries/cfsets to the new variable it doesn't work. Do I need to make the change somewhere else to? What I have done thus far: Query for login Cfset New CLIENT variable Go to new page Query

Ot: sending pdf to the browser

I have a cold fusion page that I use to populate a pdf. On the macs it downloads to the desktop first, then when clicked it opens in the browser. I need for it to just open in the browser. This info is sensitive and I can't have it litering the desktop then rely on the user delete the

Ot: another quick pdf to browser question

Thanks for the replies. They make total sense. Now I have one more simple question. I am using the CFLOCATION tag to pull up a pdf form CFLOCATION URL=http://; It shows fine on a mac, but not on a pc. I get the blank screen. I added CFCONTENT TYPE=application/pdf, but that hasn't made a

RE: Coldfusion Level 1-3 at OSU :: who is teaching it?

I'd assume its A. The Ohio State Universitywhen I went there there was the assumption that there was 1 and only 1 OSU. If you talk to people there they woud say there are others? -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 9:59 AM

OT: activepdf-clarifications

I have set up a cold fusion page- I want the queries of that page to populate my pdf. So the steps I take are: 1. set up pdftoolkit 2 set openinputFile. 3. set up queries 4. Output queries 5. In the cfoutput query statement add SetFormFieldData 6. Tlkt.CopyForm/Tlkt.ClearQueries 7. Go open new

RE: Using query2pdf

you just need to put it in as a custom tag CFX in the administrator which asks for class name and tag name. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 8:27 AM To: CF-Talk Subject: Using query2pdf Is anybody using the query2pdf tag?

RE: Using query2pdf

- Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 8:39 AM Subject: RE: Using query2pdf you just need to put it in as a custom tag CFX in the administrator which asks for class name and tag name. -Original Message

RE: Nt authenicate with a twist

So do you use CFAuthenticate first to check against the nt box then use the cfx_domainuser tag? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 5:14 AM To: CF-Talk Subject: RE: Nt authenicate with a twist We want users to be able to

Nt authenicate with a twist

We want users to be able to authenicate through their current nt login. But we also need to hook these users to a specific list. I currently have it in a sql database table- name/password/ids used to get specific list. What is the best way to use this with nt? I can't add the needed fields to

Active pdf stuck

Well I have it so the my database sends info to the pdf form through activepdf. However, I can only do one person, because the info seems stuck for a certain amount of time. ie: if I look at the info for tom jones I see his info in the pdf but if I go back to my cf pages and look up sara smith

SQL and CF5-please help

It is one of those days. Here's the problem: 1. I did a verify test for a connection to my SQL2000 server when we still had CF4.5. It verified fine. We upgraded and I went to check it/hook it up (i've been using a test access db) and suddenly it isn't verified. We haven't had any rules/etc

RE: // Simple way to print out tables?

If you want the CFStudio perfect window then pull it up- hit the print screen button then paste that onto a word doc. Then print. Easy and quick way to do it. -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:19 PM To: CF-Talk Subject:

RE: CFUPDATE and MySQL

Yes convert it to cfquery with updates- it's a good place to start. I have found a lot less problems when I use the more generic tags (e.g. form vs cfform/cfupdate vs cfquery update/etc) My issue was browser based- ie what looked pretty/worked great on pc didn't always do the same with macs.

Multiple forms

I have the code to put out to an fdf/pdf form. But I still have some problems. 1. It comes up fine for an individual form for one person. However, how do I get it so that it makes 25/100/whatever number depending on the query? My query is set up so that it pulls many people up at one time.

RE: Word,Excel-Links to

I havent' done this but saw lots of info here: http://www.cfcomet.com/cfcomet/ Hope it is of help. j -Original Message- From: Hirschman, Miriam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 9:26 AM To: CF-Talk Subject: Word,Excel-Links to Hi, I asked this question

RE: Female Programmers

Well now you're hitting on the social/political issues...girls like math, science, etc. and do as well as boys until they reach High School. Then it isn't as cool to be good at math/there's no encouragement/etc-in fact my sis who is a doc was told by her HS math teacher that she needn't bother

CFHeader

Everytime I try to use CFHEADER I get the message: The tag name CFHEADER not found in currently active versions. This is the code I was using: cfheader NAME=Content-Disposition VALUE=inline; filename= TESTlocal.fdf I can't find any docs about it not being usable. Also could this be the reason

ActivePdf

has anyone used the active pdf? How do you set the master query/related query in CF??? I've been going through all the examples that they have and I haven't come across how they do a db to form in cf. All their examples that have to do with db are in asp. Any help would be greatly

OT: Cf code with ActivePDf

Sorry for the OT post, but activepdf forums is down (and has been so for over a month) and I'm tired of hitting my head against the wall. I am trying to use active pdf toolkit to send my database query to a pdf form I found an example in their docs but haven't been able to implement

RE: Cf code with ActivePDf

presume that ReportCard.pdf is such a file? No idea what this is needed for - sorry !---This next gives me an error msg so it is commented out. ***CFSET Tlkt.SetDBMultiRowSeparator--- Steve - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

RE: Database design woes

1. Don't ever delete states- even if FL breaks off and floats away to become part of South America you will usually need that information for historical reasons! (I heard a story recently of a school that dumped all of their old courses out of the database- but it didn't dawn on them that they

RE: Database design woes (me again!)

You want to use an id/reference table anytime the information is the same repeated multiple times in your database. I've used them for occupations/jobsites/teachers/salesperson/team names/School names/Company names/Doctors list/etc. Generally they will be used when: a. info that generally

OT: Questions to ask for CF developer

I've just been asked to prepare some questions for possible new employees. He wants it general but able to gauge their knowledge. This is a 2nd interview type deal- the first one people stated yeah I have X yrs experience with CF. We don't want to get too nitty gritty but we do want to get a

RE: OT Questions to ask for CF developer

Thanks to all who responded. I've got a good idea about what to ask I appreciate the help. j ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Kill the thread (was Kill the President)

Enough already, let's get back to what we all love- cold fusion discussions! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

how do i condense this?

I have a display page that I want the user to update if it is the current quarter. How do I make my code more efficient then this stuff I have??? The only way I've gotten it to work is when I hard code the quarter- what's the best way to get rid of all of these cfif/cfelseif statements?

RE: how do i condense this?- one more thing

EQ X) CFSET GradingPeriod=XINPUT TYPE=Text NAME=Grade VALUE=#Grade# CFELSE#UCase(Grade)# /CFIF -Original Message- From: Janine Jakim Sent: Wednesday, July 18, 2001 8:55 AM To: CF-Talk Subject: how do i condense this? I have a display page that I want the user to update

RE: how do i condense this?

(Now() GT GetSubjects.BegQuarter) and (Now() LT GetSubjects.DistributionDate) cfset client.GradingPeriod = GetSubjects.Quarter INPUT TYPE=Text NAME=Grade VALUE=#Grade# cfelse #UCase(Grade)# /cfif - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL

2 probs: logout and password

1. I have been trying to do a logout that will not allow the user to use the back button on the browser. I have set client variables to 0 have cfDeleteClientVariables and still I am able to hit the back button and see the last page that I was on before logging out. However, I can no longer use

Place holder

I have a display page that shows select boxes/input boxes. Depending on the subject will depend on if they should fill the box. I have set it so they don't see a box if the field should not be filled in. Problem: On submit an update query is run. My query doesn't like blanks (loop list update

RE: Out of Space? - More Info

1.It may actually be something with the table itself and not the disk space. What type of fields are being used? Is is a local table or does it have a different database backend? I have seen weird things happen depending on what datatypes are being used. (In access I stay strictly with

select box on mac

I have made select boxes for data entry. On the pc/netscape on mac it is fine and you can tab from box to box and begin typing your entry. Unfortunately, with IE (4.5) on Mac this doesn't work the same way. Instead it forces the user to choose the box and pick from the drop down menu. And it

RE: select box on mac

browser. IE 5.0 Mac has much fewer problems... there is no reason to stay with 4.5 HTH Dick At 2:29 PM -0400 7/12/01, Janine Jakim wrote: I have made select boxes for data entry. On the pc/netscape on mac it is fine and you can tab from box to box and begin typing your entry. Unfortunately

RE: select box on mac

many problems, that I just ignore it... I don't consider it a viable browser. IE 5.0 Mac has much fewer problems... there is no reason to stay with 4.5 HTH Dick At 2:29 PM -0400 7/12/01, Janine Jakim wrote: I have made select boxes for data entry. On the pc/netscape on mac it is fine and you

query and cfif and cfset

I have a display page that I want the user to only add current information. The older info should be read only. I can not seem to get this to work- i end up with either 2 input boxes or 2 display boxes. I'm wondering if the prob stems from the queries. 1. I used two queries. One gives all the

making list update dynamic

I have made some pages that display in columns and are updatable. There are actually over 50 entries they can make which are split between several pages. To update just the page the user is editing I have hardcoded the point on the list that should be updated. Well if all stayed exactly the

pdfs, fds oh my

This is a repost. I sent this out Friday afternoon, but it never showed up again in my mailbox...sorry if you are receiving it for a 2nd time. I am trying to populate my pdf form using cf/fdf(non ActiveXmethod)-nice write up on that Max- your directions are superb and easy to follow. (If you

RE: newbie question

on your files tab you will see Allaire FTPRDS click on that and you'll be able to view all the RDSs. Right click on the invalid one and choose delete. -Original Message- From: Burns, Iain (CTO) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 10:00 AM To: CF-Talk Subject: newbie

RE: Access Help!!!

It needs to be and not--not or ((EncounterOutcomeCATID 23) or (EncounterOutcomeCATID 32) and (EncounterOutcomeCATID 27) and (EncounterOutcomeCATID 24) and (EncounterOutcomeCATID 25)) -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]]

Updates and loops and lists-Need help immediately.

I need to figure this out fast! Have a meeting in a few hoursI am trying to run an update query in a loop but it is not working. I have defined and hard coded my one variable called 'skilloffset'. I need for my query to update where DisplayNum=X + #SkillOffset# I'm not sure how to make

RE: Updates and loops and lists-Need help immediately.

Thanks- it finally works. I didn't notice the last two cfifelse (hadn't tried them yet) but the where statement worked wonders. The permnum is actually a text field hence the ''. I appreciate all your help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: Updates and loops and lists-Need help immediately.

Ooops It doesn't work..it does in Studio but when I run it off another machine/browser I get the error msg again. Why would it work ok in studio but not in the actual browser? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 1:25 PM To:

active edits

I have a form to show information for each quarter of the year (in a table). I need for users to only be able to update the current quarter- the past quarters should show but be display only. I have a table that lists the dates for the beginning/end of each quarter. My table has the fields:

RE: database modeling

Put it in one table with a status field-that is the best way to handle this issue. One field change/update (Status) in one table is easier to make then moving all the information from one table to another table when a person changes status! (If there's 2 tables someone would have to append it or

Going bonkers with an Update in table

This is beginning to drive me bananas. This is a repost that I'm hoping someone can help with. I am trying to do an update query on a table-it keeps updating only the first column of the table- with all the data updating in just that one field! Although the table seems set up correctly (ie: the

RE: Database/CF easy problem for someone.

You need to do a select distinct statement in your query. SELECT DISTINCT FSA #, Franchise Or use the Group By statement in your query (this is probably the better answer) cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName,

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

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,

Design Issue with update queries

I have a design dilemna Facts are this: 1. Each quarter grade information must be updated in each subject. Total subject + subcategories are gt 50 for each grade level. To display them in columns I am using: TD cfif Val(CourseGrade.GradeForSubject)#SubjectGrade# cfelseinput

RE: SQL Server 2000 warning

David, It's funny how timing works...I had just read this email from another list I am on and then came across yoursso I did an old copy/paste job. Hi All, I am the king of OT posts this week, but y'all know yer stuff, so... Every time I change a SQL Server TABLE, any VIEWS associated

Design Question

Ok folks I need some help with design...this is all stuff I know inside out when I'm working with Access but am struggling when I try to put it in terms of CF/Fusebox... 1. I need a login- once successfully logged in a teacher will only see his/her students. I got that. 2. So I need each for

Forms and whatnot

I am making an form for people to add information each quarter. They need to be able to compare the figures for each quarter in a table. Their quarter is set up as a stored procedure so they don't need to add which quarter they are currently editing (ie: it appends all the rows each quarter so

RE: Layered Security

long to that teacher. That way you won't have the added security on the second table. Is this what you were looking for??? Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Janine Jakim [mailto:[EMA

layered security

I need to make a "layered"login to a secure site. We are using a SQL2000 database on Windows2000 machine. I assume that I will have the user authenicate through the active directory and be recognized as being part of a "group" and sent to a specialized menu. (am I correct in that

<    1   2   3