RE: CF logins, authenticate against Novell NDS???how?

[Paul Ihrig]

yes 
i would also like to know more on the steps required for this!
-paul

> -Original Message-
> From: Steve Aylor [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 1:57 PM
> To:   [EMAIL PROTECTED]
> Subject:  Re: CF logins, authenticate against Novell NDS???how?
> 
> 
> Lanny et al...,
> 
> Care to point us NDS "newbies" in the right direction via URL to stuff on
> integrating NDS w/ cf4.5?
> 
> Any help appreciated
> 
> Steve
> 
> .
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Ultradev

[Paul Ihrig]

i just bought it & cant wait!
should get my lic for it today!

seems to be a perfect sollution for the graphic side on my noodle,
while i still peck away at learnning CF.

-paul

> -Original Message-
> From: Reynolds, Adam [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 06, 2000 9:33 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  Ultradev
> 
> Anybody used it?
> 
> Anybody think its better than a Studio/Dreamweaver 3 combination?
> 
> 
> Adam Reynolds
> ColdFusion Consultant
> HJ Heinz
> Tel: 01344 397016  Fax: 01344 397010
> Mobile: 07973 386620
> Email: [EMAIL PROTECTED]
> 
> **
>  This email and any attachments are confidential and solely
>  for the use of the intended recipient.  They may contain
>  material protected by legal professional or other privilege.
>  If you are not the intended recipient or the person responsible
>  for delivering to the intended recipient, you are not authorised
>  to and must not disclose, copy, distribute or retain this email
>  or its attachments.  Although this email and its attachments
>  are believed to be free of any virus or other defect, it is the
>  responsibility of the recipient to ensure that they are virus free
>  and no responsibility is accepted by the company for any
>  loss or damage arising from receipt or use thereof.
> 
> **
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Macromedia Ultradev

[Paul Ihrig]

i am thinking about creating a cf / ud site to guide newbies [like myself]
into the world of data manipulation then on to bigger & better things inside
CF.
if you think this might be of interest or other coments let me know.

again this is just an idea.
the documentation blows.

-paul

> -Original Message-
> From: Larry C. Lyons [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 20, 2000 9:13 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Macromedia Ultradev
> 
> I just got in my copy of UltraDev and have just started working with it
> for the last couple of days. So far I doubt it will replace CFStudio.
> Rather it will replace the copy of Dreamweaver 3 that's on my machine.
> The real impact of UD is going to be with the 3rd party extensions that
> are just now starting to come out. For instance Massimo Foti is
> developing a set of CF related extensions that look very promising, such
> as a login page, various redirects based on an empty record set, a
> repeated region and a CF OUTPUT. Over the next few months I figure these
> extensions will be getting more and more sophisticated.
> 
> I expect UD to improve our overall work flow, not replace Studio.
> 
> regards,
> 
> larry
> 
> -- 
> Larry C. Lyons
> ColdFusion/Web Developer
> EBStor.com
> 8870 Rixlew Lane, Suite 201
> Manassas, Virginia 20109-3795
> tel: (703) 393-7930 x253
> fax: (703) 393-2659
> http://www.ebstor.com
> http://www.pacel.com
> email: [EMAIL PROTECTED]
> 
> Chaos, panic, and disorder - my work here is done.
> --
> 
> Doug Nottage wrote:
> > 
> > How do you see UltraDev working in your current development environment?
> > 
> > Where do you prefer it over Studio or other tools?
> > 
> > Is it worth getting and if so for what reasons?
> > 
> > --Doug
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

cfMail.. what am i doing wrong?

[Paul Ihrig]

hello.
have a form that pulls info in about a class & its times.
at the bottom of it you sign up with name & such.
it submits the content into a mdb.

when i try & insert 
to myself, from myself, (just for testing, before i use to =
#useremail#)
subject #whatever#

then hit submit.
i get like 200 results in groups of 7 or so  ???
is because i have it positioned incorrectly ?

i want to send the content from the form tag ?
would a loop do this? and why would it stop at 200 ?

any help would be great.

-paul
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfMail.. what am i doing wrong?

[Paul Ihrig]

sure.
here is just a part of it.
i stopped when i got nailed with 200 replies.

the code is ugly. [been playing with ultraDev]









  
 
  First
Name




 
  Last 
Name




 
  Email




 
  Date Offerd



   
 
# LSDateFormat(rsDatesOfferd.ClassDate, ', 
DD, 
  ') #
 

 
 


 








  
  





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfMail.. can i get some help!

[Paul Ihrig]

Can any one please help me to do this right!
i want to send a confimation message 
from
ClassTeacher, ClassEmail FROM tbl_Class 
to
FirstName, LastName, Email FROM tbl_Employee 
subject
ClassName FROM tbl_Class

With a comfimation if they are the first 25 to sign up
or a sorry message if they are after 25.

when i tried this befor
i put the  tag in the form tag & i got 200 messages sent to my self!

I have read Wack, & MCF.

Any help would be great!

sorry if this is to large of an email.


thank you very much
-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
Home:   [EMAIL PROTECTED]
614 449-1681
[EMAIL PROTECTED]
icq: 47658358



-Code here-


 

// *** Insert Record:  construct a sql insert statement and execute it
MM_editAction = CGI.SCRIPT_NAME;
If (CGI.QUERY_STRING  NEQ "") MM_editAction = MM_editAction & "?" &
CGI.QUERY_STRING;
If (IsDefined("MM_insert")) {

  MM_datasource = "practice";
  MM_username = "";
  MM_password = "";
  MM_tableName = "tbl_SignUp";
  MM_fields =
"slctName,SU_EmployeeID,none,none,NULL,slctDate,SU_DateOfferdID,none,none,NU
LL";
  MM_redirectPage = "ThankYou.htm";

  // create the insert sql statement
  MM_tableValues="";
  MM_dbValues="";
  MM_fieldsArray = ListToArray(MM_fields,",");
  For (i=1; i+4 LE ArrayLen(MM_fieldsArray); i=i+5) {
FormVal = IIf(IsDefined(MM_fieldsArray[i]),"FORM." &
MM_fieldsArray[i],DE(""));
Delim =IIf(MM_fieldsArray[i+2] NEQ
"none","MM_fieldsArray[i+2]",DE(""));
AltVal =   IIf(MM_fieldsArray[i+3] NEQ
"none","MM_fieldsArray[i+3]",DE(""));
EmptyVal = IIf(MM_fieldsArray[i+4] NEQ
"none","MM_fieldsArray[i+4]",DE(""));
If (FormVal EQ "") {
  FormVal = EmptyVal;
} Else {
  If (AltVal NEQ "") {
FormVal = AltVal;
  } Else If (Delim EQ "'") {  // escape quotes
FormVal = "'" & Replace(FormVal,"'","''","ALL") & "'";
  } Else {
FormVal = Delim & FormVal & Delim;
  }
}
If (i GT 1) {
  MM_tableValues = MM_tableValues & ",";
  MM_dbValues = MM_dbValues & ",";
}
MM_tableValues = MM_tableValues & MM_fieldsArray[i+1];
MM_dbValues = MM_dbValues & FormVal;
  }
  MM_insertStr = "insert into " & MM_tableName & " (" & MM_tableValues & ")
values (" & MM_dbValues & ")";

  // build the redirect URL
  If (MM_redirectPage EQ "") MM_redirectPage = CGI.SCRIPT_NAME;
  If (Find("?", MM_redirectPage) EQ 0 AND CGI.QUERY_STRING NEQ "")
MM_redirectPage = MM_redirectPage & "?" & CGI.QUERY_STRING;
}



#PreserveSingleQuotes(MM_insertStr)# 




SELECT EmployeeID, FirstName, LastName, Email FROM tbl_Employee ORDER BY
LastName; 


SELECT SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 18 


SELECT ClassDate FROM tbl_Class WHERE ClassID = 17 


SELECT ClassDate FROM tbl_Class WHERE ClassID = 18 


SELECT ClassID, ClassName, ClassTeacher, ClassEmail, ClassDescription,
ClassRoom, 
ClassStartTime, ClassEndTime, ClassDate FROM tbl_Class WHERE ClassID = 17 OR
ClassID 
= 18 


SELECT SignUpID, SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 17














// *** Recordset Stats, Move To Record, and Go To Record: set stats
variables

// set the record count
rsDate01_total = rsDate01.RecordCount;

// set the number of rows displayed on this page
If (rsDate01_NumRows LT 0  OR  rsDate01_NumRows GT rsDate01_total) {
  rsDate01_NumRows = rsDate01_total;
} Else If (rsDate01_NumRows EQ 0) {
  rsDate01_NumRows = 1;
}

// set the first and last displayed record
rsDate01_first = Min(1, rsDate01_total);
rsDate01_last  = Min(rsDate01_NumRows, rsDate01_total);


// *** Recordset Stats, Move To Record, and Go To Record: set stats
variables

// set the record count
rsDate02_total = rsDate02.RecordCount;

// set the number of rows displayed on this page
If (rsDate02_NumRows LT 0  OR  rsDate02_NumRows GT rsDate02_total) {
  rsDate02_NumRows = rsDate02_total;
} Else If (rsDate02_NumRows EQ 0) {
  rsDate02_NumRows = 1;
}

// set the first and last displayed record
rsDate02_first = Min(1, rsDate02_total);
rsDate02_last  = Min(rsDate02_NumRows, rsDate02_total);




Practice Manegment Sign Up





   
A 
  limit of 25 spaces are available per class per day.
  You will be notified if you are selected for the class &
time.
  
   
 
    people have
signed 
up so far. 

 #rsDate01_total#  
people for # LSDateFormat(rsDisplayDate01.ClassDate,
', 
   DD, ') #.
#rsDate02_total#  
people for # LSDateFormat(rsDisplayDate02.ClassDate,
', 
   DD, ') #.

  
   
 
  Course

 #rsClass.ClassName#
  
   
 
  Course
Description

#rsClass.ClassDescription# 
  
  
   
 
  Course
Instructor


 mailto:#rsClass.ClassEmail#">#rsClass.ClassTeacher# 
  
  
   
 
  Course
Room

 #rsClass.ClassRoom#
  
   
 
  Start
Time

 # 
LSTimeFormat(rsClass.ClassSta

CFMail::Urgent::..::please help:: local env. VS. production env.

[Paul Ihrig]

on the production server the code below from the CF help works fine.
in my local enviroment i get 100 messages back.

what is wrong with my local CFMAIL?





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFMAIL Urgent Help Needed...Please!

[Paul Ihrig]

on local test i get 100 results which is Bad!
on production server i get 1 result, good!

what is wrong with my local cfmail or server?
Is somthing corrupted?
same mail server.

> >i am using PWS on my laptop.
> >win 98.
> >CF SEVRER 4.5
> >the same mail server settings for both local enviroment & production
sever.
> >cmhgate.columbus.nbbj.com

in the exaple below the to: filed
is from a url variable email

> >http://www.columbus.nbbj.com/sendmail.cfm?[EMAIL PROTECTED]

again this is just a test.
i will be doing it all with variables once i know my local enviroment is
working correctly
i dint know why my local sever is hosed.
is there a cfmail.dll on my local machine that got messed up?

here is the sample code, very simple

thanks
-paul



Sending a simple email



Sample email

This is a sample email to show basic email capability.



The email was sent.





-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
Home:   [EMAIL PROTECTED]
614 449-1681
[EMAIL PROTECTED]
icq: 47658358

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFMAIL Urgent Help Needed...Please!

[Paul Ihrig]

just found this in my local mail log

"Warning","TID=-1754369","06/29/00","09:30:34","Unable to move the spooled
mail file, C:\CFUSION\MAIL\spool\E0C3.cfmail. Access is denied.."

what now?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFMAIL Urgent Help Needed...Please!

[Paul Ihrig]

nope same mail server.
no atatchments.

just get errors on my local server but not on the production server.

allire wnts 150 bucks to talk to me.

have posted on forums.
no luck.

this really sucks.
-paul
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: RDS port

[Paul Ihrig]

Dave.
Doe this work for the Admin Portion or CF Server Ent?

Right now ours is set to the Severs default IP Address from the nick card.
The problem is that it is only internal.
So i can only hit the CF Server within the building.

Although the sevre has external ip address & domain names, 
I cannot figure out how to hit the server from home.

any advice would be great!
thanks.

-paul

> -Original Message-
> From: Dave Watts [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 04, 2000 12:57 PM
> To:   [EMAIL PROTECTED]
> Cc:   [EMAIL PROTECTED]
> Subject:  RE: RDS port
> 
> > How can i configure RDS port (default 80) on a CF 4.5.1
> > enterprise server?
> 
> RDS simply monitors requests to the web server for a specific file:
> 
> http://www.yourserver.com/CFIDE/main/ide.cfm
> 
> So, you can manage access to that file in whatever ways your web server
> allows. You can put that file behind a different virtual server, and
> configure that virtual server how you want it. You could run it on a
> different port, or use SSL or NTLM Authentication, filter access by IP
> address, or whatever else you want to do.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

How to Count? or Record Count?

[Paul Ihrig]

Ok this is going to sound a bit odd since i am not sure how to word it.

i have my little query: [in my admin page for viewing who has signed up for
the class]

[[from dataview01.cfm]]


SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName,
tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID,
tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID,
tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, tbl_SignUp.Completed,
tbl_SignUp.CreateDate 
FROM tbl_Employee, tbl_Class, tbl_SignUp 
WHERE EmployeeID = SU_EmployeeID
AND ClassID = SU_DateOfferdID 
AND ClassName = 'Human Resource Mgmt'
ORDER BY #DefOrder#


Which is grabbing a list of employees which could have signed up for 1
class, given on 2 differnt dates.

My problem is, that the class size needs to be limited to 25 people.
This is stated on my main form.

it also shows how many people are currently singed up for class 01 & class
02.
[[from signup01.cfm]]


SELECT SignUpID, SU_DateOfferdID 
FROM tbl_SignUp 
WHERE SU_DateOfferdID = 1



SELECT SU_DateOfferdID 
FROM tbl_SignUp 
WHERE SU_DateOfferdID = 2


[[the display]]

A limit of 25 spaces are available per class per day.
You will be notified if you are selected for the class & time.
.   #rsDate01_total#  people have signed up so far
for 
# LSDateFormat(rsDisplayDate01.ClassDate, ', 
   DD, ') #.
  
#rsDate02_total#  
people for # LSDateFormat(rsDisplayDate02.ClassDate,
', 
   DD, ') #

So, on the form i show how many have signed up.

But on the admin page, i cant figure out how to show who has signed up in
sequential order.
Because on one admin page i have 2 seperate date/times they could sign up.

Its not really abig deal.
i would just like to know how to get the number of the last insert Total + 1
as the number that realates to the student who signed up.??
I know i should have used a sepereate table for each Class/time.

mabey i will redo it from the ground up.
But since it is 10 different classes with 2 times each, spread out over the
next year.
I wanted to be able to track Student/employees progress through this
"Practice Manegment" class.

lol
no one will read this!

Thanks if you do!

-paul

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cold Fusion Studio Vs Dreamweaver Ultradev

[Paul Ihrig]

alot of cgi stuff too.
i have been using it for a few days now.

i like that you can through up a decently designed page that pulls data in, 
in a few minute & preview it right there.

What i dont like is its reformating of my code, from cf.
ud, seems not to understand some very basic list functions.

but its pretty neat to slash out a few pages quickly.

wont replace studio any time soon.
-paul

> -Original Message-
> From: Francis NART [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 12, 2000 5:18 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Cold Fusion Studio Vs Dreamweaver Ultradev
> 
> Many many CFSCRIPTS in the the CFML code...
> I think that the purpose of this is to be able to switch from asp or Jsp
> to 
> CFML for example but the code looks really strange to me.
> 
> 
> At 19:06 11/07/00 -0400, vous avez écrit:
> 
> >Hello All:
> >
> >I'm Currently evaluating ultradev for asp and cold fusion applications,
> >anybody have any comments on ultradev
> >I would appreciate any suggestions, comments, gripes ect..
> >
> >thanks in 
> >
> >Dana E. Johnson
> >Sr. Web Developer
> >CIT
> >VTF/Technology Financing Services
> >[EMAIL PROTECTED]
> >(904) 620-7458
> >
> >
> >-
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit 
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or 
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> 
> >the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: How to Count? or Record Count?

[Paul Ihrig]

Ok.
I am able to get one class id inserted besed on the record count.
My problem now is at the bottom of this page.

it needs to be conditional on wether the insert is for date/time 01 or
date/time 02.
But how is my form suposed to know what date has been selected befor the
actual submit button is hit?

i need a 







any help would be awsome!
thanks

-paul






SELECT ClassID, ClassName, ClassTeacher, ClassEmail, ClassDescription,
ClassRoom, 
ClassStartTime, ClassEndTime, ClassDate 
FROM tbl_Class 
WHERE ClassID = 1 
OR ClassID = 2 



SELECT SignUpID, SU_DateOfferdID 
FROM tbl_SignUp 
WHERE SU_DateOfferdID = 1 



SELECT SU_DateOfferdID 
FROM tbl_SignUp 
WHERE SU_DateOfferdID = 2 



   
 
  # LSDateFormat(rsClass.ClassDate, ',  DD, ') #




 



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: How to Count? or Record Count?

[Paul Ihrig]

Katrina 
close, i can Really use that.

i wanted to create a number list, just the way you explained.
that wouldnt be entered into any table, but just generated.

so that when some one sign up twice & i delete them from the admin page
the number would be recaluculated? also so i can keep track of how close to
25 for each class.

4 signed up for class date of 8/08/00   
3 signed up for class date of 8/17/00   

 Name   Class
ClassDateSignUp Date  Delete 

01 Aldrich Merrill  Human Resource Mgmt  8/08/00
7/12/00 || 3:32:01 PM  Delete  
02 Schardt Sydney Human Resource Mgmt  8/08/00
7/11/00 || 3:24:13 PM  Delete  
03 Kelly Kathy  Human Resource Mgmt  8/08/00
7/11/00 || 6:40:09 PM  Delete  
01 Patton Stephanie Human Resource Mgmt  8/17/00 7/12/00 ||
7:14:46 AM  Delete  
04 Ihrig Paul   Human Resource Mgmt  8/08/00
7/12/00 || 8:17:13 AM  Delete  
02 Nichols Todd Human Resource Mgmt  8/17/00
7/12/00 || 8:18:00 AM  Delete  
03 Chobo Jennifer   Human Resource Mgmt  8/17/00
7/12/00 || 8:19:47 AM  Delete   

Thank a bunch!

-paul
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 12, 2000 1:33 PM
> To:   [EMAIL PROTECTED]
> Subject:  Re: How to Count? or Record Count?
> 
> I could be totally wrong here but I'm assuming that tbl_SignUp.CreateDate
> is the time that they signed up.  Am I right?
> 
> If I am you could just do this
> 
> 
> SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName,
> tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID,
> tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID,
> tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, 
> tbl_SignUp.Completed,
> tbl_SignUp.CreateDate 
> FROM tbl_Employee, tbl_Class, tbl_SignUp 
> WHERE EmployeeID = SU_EmployeeID
> AND ClassID = SU_DateOfferdID 
> AND ClassName = 'Human Resource Mgmt'
> ORDER BY tbl_Class.ClassDate, tbl_SignUp.CreateDate, #DefOrder#
> 
> 
> This sort order would put the classes together, then put them in order by 
> who signed up when, then whatever #DefOrder# is.
> 
> Is that what you wanted?
> 
> --K
> 
> 
> Katrina Chapman
> Consultant 
> Ameriquest Mortgage
> 
> 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Can i use 2 datasources in one app?

[Paul Ihrig]

Quick question.
Can I use 2 different datasources in a CF page?

Say I use Phone.mdb (datasource DB_Phone)
for all my employee info, that is updated on a regular basis.

Then I have a Class sign up mdb. (datasource Class)

Can I just query the DB_Phone to get the employeeID & the insert it
into the Class datasource?

Currently I have just been copying the table employee into a new mdb
for each new little app I through together.
The problem is when a employee is added or deleted to DB_Phone, none
of the other databases know about it.

Also, would a linked table in access work in ColdFusion?
I have never seen the tables that where linked show up in the
DataBase Tab in CF.

Thanks a bunch

-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

OT: access *.mdb ho do i?

[Paul Ihrig]

How do I create a relative link to another table, in another *.mdb in
access.
Right now I keep getting the linked tables as absolute.
This won't work on our web server.

Thank you
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Why Cant i see, linked Tables in the DB tab in studio?

[Paul Ihrig]

OK!
I am able to use linked tables in access in CF Studio!
Never knew that! Saves me a lot of time & keeps my stuff normalized I think.

But WHY can't I see the linked table in the DataBase Tab in CF Studio?

Is there a work around, cheat or quick fix for this?

I use the DB Tab on a regular basis to build my SQL statements & to
visualize my DB

Any suggestions would be great!

Thanks

-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: access *.mdb ho do i?

[Paul Ihrig]

I tried to create a shared folder on our server called PhoneData
But when I try to do the linked table, it through up this error.


Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error) 
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot open the file '\\nbbjcmhweb\PhoneData\phone02.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (61:1) to (61:52).
Date/Time: 07/17/00 13:04:53
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 10.101.4.37
HTTP Referer: http://inhouse/fs/fsrite.cfm  

There are no permissions set, other then the default.
I have no idea what to do?

Any help would be greatly appreciated.

-paul



-

How do I create a relative link to another table, in another *.mdb
in access.
Right now I keep getting the linked tables as absolute.
This won't work on our web server.

Thank you
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: List slowdown problems and solutions

[Paul Ihrig]

I have learned more about web development in general & CF to boot from this
list.
Other then WACK it is my greatest resource, that I use on an hourly basis
here at work.
I would defiantly kick in a few bucks a month or so to help out.

Keep up the good work.
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: WWW.E-BURSA.COM

[Paul Ihrig]

25 seconds from columbus ohio on a t1
-paul

-Original Message-
From:   Gunawan Hadikusumo [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 12, 2000 6:01 AM
To: '[EMAIL PROTECTED]'
Subject:WWW.E-BURSA.COM

IS ANY BODY HERE ANY DIFFICULTY IN ACCESSING MY SITE:

WWW.E-BURSA.COM   ?

I WANT TO KNOW WHERE DO YOU ACCESS MYSITE ( COUNTRY ,PUBLIC INTERNET
CAFÉ OR
PERSONAL),
AND HOW FAST  YOU GOT.


THANK'S FOR ALL PARTICIPANTS


GUNAWAN


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFMAIL and recordsets

[Paul Ihrig]

Do you have a:
Hello #username# 

Hope that helps.
-paul

-Original Message-
From:   Matt Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, July 18, 2000 7:34 AM
To: ColdFusion Discussion List
Subject:CFMAIL and recordsets

 Hi all,
I have a query that returns a record set of username, password and
email.  I
then use  to send each person their correct authentication,
no big
deal.  My problem is when I want my message text to come from a form
field,
 does not parse my #'s at all.

Ex: form field 'name=document'



Any CF variables I put into the form field like "Hello #username#,"
are not parsed by CF.  Does anyone know why this is occurring?

 TIA,
 Matt



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

OT: Web Cam's

[Paul Ihrig]

Does any one have any suggestions for web cam's?
I need to set one up for an architectural project.
Have never done one so I need to know what you guys think
Advice on model of camera, server config's client needs would be awesome!

Mabey even one of you knows of a reseller.

-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help on 2 datasource query

[Paul Ihrig]

 can you help me on that 2 datasource query?

with the 2 datasource's:
http://206.183.250.42/Practiceman/Class01/DataView01A.cfm
 
this is an admin page.
only returns 1 result it should return many.

http://206.183.250.42/Practiceman/Class01/DataView01.cfm
 
this returns the correct results.
but only uses 1 datasource.

you can grab the files if you just put in 
http://206.183.250.42/Practiceman/Class01/
 

directory browsing is on.

Any help would be great.
Thank You

 
-paul
 
Web Developer, NBBJ
Work: [EMAIL PROTECTED]  
614 241-3534
Home: [EMAIL PROTECTED]  
614 449-1681
[EMAIL PROTECTED]  
icq: 47658358

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Web Cam's

[Paul Ihrig]

Thanks Ken.
But I need an out door solution.
Its to view the construction of a building.

-paul

-Original Message-
From:   Ken Monroe [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, July 19, 2000 9:13 AM
To: [EMAIL PROTECTED]
Subject:RE: Web Cam's

Try an AXIS camera:
http://www.axis.com/products/camera_servers/

Very nice
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Please Help! Linked Tables in Access :2nd post:

[Paul Ihrig]

Hello & thank you.

I have an access *.mdb table that I want link to another access table on the
server.
So that my employee info is updated as it is changed in this other *.mdb

I have tried every thing I know of, but I am still getting access rights
problems from the web server.
I cant seem to be able to link the *.mdb with a relative path.
I have tried absolute paths such as \\webserver\datadir\linkeddata.mdb
<\\webserver\datadir\linkeddata.mdb> 
To no avail.

Is it possible to do this on the server?
I can do it just fine on my local machine, but it all points to C: not D:

My server admin doesn't want me to install access on the main server to do a
test.

I know this may sound stupid & off track, but it really would be useful with
CF.

Thanks.
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Please Help! Linked Tables in Access :2nd post:

[Paul Ihrig]

Chris, thank you.
I suspected that was the case.
I will do that.

Also I just got Crystal Reports which I think may be able to help me in this
issue of querying 2 separate datasources.
Again thanks
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

WOT: ntfs, how do i?

[Paul Ihrig]

I need to create a new partition on my laptop so I can mirror my production
server a bit better.

I am running NT with a NTFS on my C: Drive.
I would like to create a d drive.

I have no idea how to do this.
I goofed with the disk admin tool, but it wouldn't let me.

I know this is OT, but it does relate to my CF environment, especially with
the ways I want my databases to talk to one another.

Thank You!

-paul

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ntfs, how do i? ::Thank You::

[Paul Ihrig]

Steve, thank you.
That worked like a charm.

Seems like having the dir. structure the same as the web server is the only
way to use linked fields in access.

Again Thank You.

-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ntfs, how do i? ::Thank You::

[Paul Ihrig]

RDBMS?
What are those?
-paul

-Original Message-

>From what I remember of Access, most of the linking functionality (fields,
tables, etc.) is based on absolute paths which makes the development <->
production migration a pain. All the more reason to move to an RDBMS if
possible.

Steve


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

WOT: Frames/sets how to give a URL?

[Paul Ihrig]

Hello.
I would like to give some one a direct url like
http://inhouse/education/education.htm
  
but it only shows the page.

I would like it to display in its proper frame set.
http://inhouse   has 3 frames in the frame set.

The page for education goes into :


do you know what I want then?
To email a link to a specifice page in a framset.
Like

http://inhouse?frameset.Main%20Page=education/education.htm
 

is this possible?

Thank you
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Digital clock display

[Paul Ihrig]

This works for me:

Hope it helps
-paul


Got the Time , Buddy?

 


   
  
#todayDate# 
 
  
  
  
  
  
  
  
  
  
  
  

 
 
  function tick() {
  var hours, minutes, seconds, ap;
  var intHours, intMinutes, intSeconds;
  var today;

  today = new Date();

  intHours = today.getHours();
  intMinutes = today.getMinutes();
  intSeconds = today.getSeconds();

  if (intHours == 0) {
 hours = "12:";
 ap = "Midnight";
  } else if (intHours < 12) { 
 hours = intHours+":";
 ap = "A.M.";
  } else if (intHours == 12) {
 hours = "12:";
 ap = "Noon";
  } else {
 intHours = intHours - 12
 hours = intHours + ":";
 ap = "P.M.";
  }

  if (intMinutes < 10) {
 minutes = "0"+intMinutes+":";
  } else {
 minutes = intMinutes+":";
  }

  if (intSeconds < 10) {
 seconds = "0"+intSeconds+" ";
  } else {
 seconds = intSeconds+" ";
  } 

  timeString = hours+minutes+seconds+ap;

  Clock.innerHTML = timeString;

  window.setTimeout("tick();", #Attributes.Ticks#);
}

window.onload = tick;




 




-Original Message-
From:   Adrian Cooper [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, July 27, 2000 11:09 AM
To: [EMAIL PROTECTED]
Subject:Digital clock display

Somewhat OT I know - but does anyone know of a piece of code for displaying
a
nice digital clock and peferably date on a CF based Website?

Thanks.

Adrian.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Commenting Text in Studio

[Paul Ihrig]

If you have your Quick Bar open.
Just click on the CFML Basic Tab & you will see the  to a block =
of text. I can't remember how he did that.

I can't find reference to that in the books or Help. I would appreciate =
it if you could refresh my memory. TIA.

Regards,

Paige

--=_NextPart_000_0009_01BFF832.922450D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi All,
 
I saw someone at the last sig click on =
an icon in=20
the upper right corner (I believe) in Studio that automatically added =
the=20
 to a block of text. I can't remember how he did=20
that.
 
I can't find reference to that in the =
books or=20
Help. I would appreciate it if you could refresh my memory. =
TIA.
 
Regards,
 
Paige

--=_NextPart_000_0009_01BFF832.922450D0--


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Rackmount Monitor/Keyboard/Mouse Switches

[Paul Ihrig]

We use a Compaq set up

-Original Message-
From:   Duane Boudreau [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 01, 2000 1:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject:RE: Rackmount Monitor/Keyboard/Mouse Switches

Check out:

http://www.pcconnection.com/scripts/productdetail.asp?product_id=140247

Duane Boudreau,
eMPower Project Manager
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249 x114
Fax: 603-594-0258



> -Original Message-
> From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 01, 2000 1:22 PM
> To: [EMAIL PROTECTED]
> Subject: OT: Rackmount Monitor/Keyboard/Mouse Switches
> 
> 
> My apologies for the off topic post, but I rarely receive 
> responses off the
> CF-Community list. Anyway, on to the question.
> 
> What's everyone using for rack mount monitor/keyboard/mouse 
> switches? We're
> a little dissatisfied with our current solution.
> 
> We're looking for a piece of hardware that:
> 
> 1. Requires absolutely no software loaded on the server.
> 2. Can support (preferably) up to 16 servers with a single unit.
> 3. Supports true hardware emulation (not a scenario in which the 
> switch has
> to be turned to a server when it boots so that the server picks up the
> keyboard and mouse)
> 
> Any suggestions would be greatly appreciated.
> 
> Thanks.
> 
> Benjamin S. Rogers
> Web Developer, c4.net
> voice: (508) 240-0051
> fax: (508) 240-0057
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

rds :: cf 5.0 :: localhost

[Paul Ihrig]

for some reason i cant get rds to work with either localhost or 127.0.0.1
i never ran into this before.

this in for my local copy of cf-server 5 & studio 5

but has been going on since i installed dwmx & cfservermx
any ideas would be great

-paul
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: rds :: cf 5.0 :: localhost

[Paul Ihrig]

got it.
just had to move the main dir inside the cfide dir.
thanks Mike!

-paul

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: COM :: CF :: Wolfenstein & Q3

[Paul Ihrig]

well...
if any one want to help me with this 
i would appreciate it.

would give access to rcon while we work on it & 
Private password, so when the server fills to 22-28
you can have one of the reserved private slots!

?? : ] ??

just something goofy to play with 
i know the gaming community would use..

-paul
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: COM :: CF :: Wolfenstein & Q3

[Paul Ihrig]

well i just did it using q3plug & the sets variable in my maprotate.cfg

now it works fine

http://www.forumplanet.com/planetwolfenstein/topic.asp?fid=1692&tid=646541

-paul


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

inmajic db text works

[Paul Ihrig]

any one here use inmajic?
we have version 4

i never played with it, but our librarian uses it to post articles & such

i am trying to apply a style sheet to it with no success
other then on the form pages, but not the results 

which are generated by a dbtwpub.dll

so if you know what im talking about & give me any pointers, i would
appreciate it!

thank you

-paul

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Date Time Manipulations in Query?

[Paul Ihrig]

ok i have this query

once the results are generated 
i can do this, below...
but i would like to be able to do the same thing in the select query.
so i can do some checks in my where statements.

how would i do the Years At Firm: & Total Years Experience: in a select
query?

hire date: #DateFormat(HIRE_DATE, "mm/dd/")#
years other firms: #LSNumberFormat(YEARS_OTHER_FIRMS)#
Years At Firm: #YearsAtFirm#  #TotalD#
Total Years Experience: #TotalYearsEx1#

Thank You
-paul





SELECT 
tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.TitleID,
tblEmployee.PracticeGroupID, tblEmployee.FirstName, tblEmployee.LastName,
tblEmployee.FloorID, tblEmployee.Email, tblEmployee.EmployeePhoto,
tblEmployee.StatusID, tblEmployee.HIRE_DATE, tblEmployee.YEARS_OTHER_FIRMS, 
tblStudio.StudioID, tblStudio.StudioName, tblStudio.OfficeID, 
tblOffice.OfficeID, tblOffice.City, tblJobTitle.TitleID, tblJobTitle.Title,
tblFloor.Floor, 
tblPhone.PhoneID, tblPhone.PhoneTypeID, tblPhone.PhoneNumb,
tblEmplDegree.EMPLOYEE_DEGREE, tblEmplDegree.EMPLOYEE_ID,
tblEmplDegree.INSTITUTION, tblEmplDegree.YEAR_DEGREE_EARNED,
tblEmplDegree.DEGREE_SPECIALTY, tblEmplDiscipline.DISCIPLINE_NAME_EMPL,
tblEmplRegistration.DATE_EARNED_REGISTRATION,
tblEmplRegistration.STATE_REGISTERED
FROM tblEmployee, tblStudio, tblOffice, tblJobTitle, tblFloor, tblPhone,
tblEmplDegree,tblEmplDiscipline, tblEmplRegistration
WHERE tblEmployee.StatusID <> 0
AND tblEmployee.StudioID = tblStudio.StudioID
AND tblEmployee.TitleID = tblJobTitle.TitleID
AND tblEmployee.FloorID = tblFloor.FloorID
AND tblEmployee.EmployeeID = tblPhone.EmpResID
AND tblStudio.OfficeID = tblOffice.OfficeID
AND tblPhone.PhoneTypeID = '1'



AND tblEmployee.StudioID = #LSParseNumber(FORM.StudioID)#




AND tblEmplDegree.EMPLOYEE_ID=tblEmployee.EmployeeID
AND EMPLOYEE_DEGREE LIKE '%#Trim(FORM.EMPLOYEE_DEGREE)#%'




AND tblEmplDegree.EMPLOYEE_ID=tblEmployee.EmployeeID
AND INSTITUTION LIKE '%#Trim(FORM.INSTITUTION)#%'




AND tblEmplDegree.EMPLOYEE_ID=tblEmployee.EmployeeID
AND DEGREE_SPECIALTY LIKE '%#Trim(FORM.DEGREE_SPECIALTY)#%'




AND tblEmplDegree.EMPLOYEE_ID=tblEmployee.EmployeeID
AND YEAR_DEGREE_EARNED BETWEEN #Year(FORM.S_year_degree_earned)# AND
#Year(FORM.E_year_degree_earned)#




AND (tblPhone.PhoneNumb LIKE '%#Trim(FORM.Phone)#%')


ORDER BY LastName;
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Date Time Manipulations in Query?

[Paul Ihrig]

ok

this is what i got to work in my select now.



SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm,
#Year(todayDate)# - Year(HIRE_DATE) + YEARS_OTHER_FIRMS AS
TotalYearsExperience,

But if the YEARS_OTHER_FIRMS in NULL/Blank or Zero
then the alias TotalYearsExperience doesnt generate.

So how can i force a null to 0 in my select.
can i use a cfif in the select part?

Thanks Again

befor i was overriding this by
cfif

hire date: #DateFormat(HIRE_DATE, "mm/dd/")#
years other firms: #LSNumberFormat(YEARS_OTHER_FIRMS)#
Years At Firm: #YearsAtFirm#  #TotalD#
Total Years Experience: #TotalYearsEx1#
 

-paul
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Date Time Manipulations in Query?

[Paul Ihrig]

Thanks Allen.
that didn't work either
i am trying this

but with no success


SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm, #Year(todayDate)# - Year(HIRE_DATE) AS
TotalYearsExperience,#Year(todayDate)# - Year(HIRE_DATE) +
YEARS_OTHER_FIRMS AS TotalYearsExperience,

-paul



-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 10:00 AM
To: CF-Talk
Subject: RE: Date Time Manipulations in Query?


What about this ???


SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm,
#Year(todayDate)# - Year(HIRE_DATE)AS TotalYearsExperience
WHERE YEARS_OTHER_FIRMS IS null

UNION

SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm,
#Year(todayDate)# - Year(HIRE_DATE) + YEARS_OTHER_FIRMS AS
TotalYearsExperience 
WHERE YEARS_OTHER_FIRMS IS NOT null

Not sure if it helps, didn't try it out!

@llan



-Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 23, 2002 3:49 PM
To: CF-Talk
Subject: RE: Date Time Manipulations in Query?

ok

this is what i got to work in my select now.



SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm,
#Year(todayDate)# - Year(HIRE_DATE) + YEARS_OTHER_FIRMS AS
TotalYearsExperience,

But if the YEARS_OTHER_FIRMS in NULL/Blank or Zero
then the alias TotalYearsExperience doesnt generate.

So how can i force a null to 0 in my select.
can i use a cfif in the select part?

Thanks Again

befor i was overriding this by
cfif

hire date: #DateFormat(HIRE_DATE, "mm/dd/")#
years other firms: #LSNumberFormat(YEARS_OTHER_FIRMS)#
Years At Firm: #YearsAtFirm#  #TotalD#
Total Years Experience: #TotalYearsEx1#
 

-paul


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ORDER BY question

[Paul Ihrig]

ok. ASC & DESC don't work on this one.

i want to be able to ORDER BY in a specific order
such as
ORDER BY tblJobTitle.TitleID='25,26,28,4'

is that possible?
if not how else could i do it...




Thanks

-paul

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

ok. ASC & DESC don't work on this one.

i want to be able to ORDER BY in a specific order
such as
ORDER BY tblJobTitle.TitleID='25,26,28,4'

is that possible?
if not how else could i do it...




Thanks

-paul
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

Man!
you guys went way over my head hear!
: ]

for this purpose
since there are only 4 separate groupings
i may just do 4 separate queries.

not sure.

thought i could do it like
Order By tblJobTitle.TitleID=25, tblJobTitle.TitleID=26,
tblJobTitle.TitleID=28, tblJobTitle.TitleID=4;


-paul
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

ok
tried brians

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]'instr' is not a recognized
function name.
 

with



SELECT  LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as
Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID,
tblEmployee.StudioID, tblEmployee.StatusID, tblEmployee.TitleID,
tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName,
tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb,
tblPhone.PhoneTypeID, tblFloor.floor, tblJobTitle.TitleID, tblJobTitle.Title
FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor, tblJobTitle
WHERE tblEmployee.studioid = tblStudio.studioid
AND tblEmployee.TitleID = tblJobTitle.TitleID 
AND tblOffice.OfficeID = tblStudio.OfficeID
AND tblJobTitle.TitleID IN (25,26,28,4)
AND tblPhone.EmpResID = tblEmployee.EmployeeID
AND tblPhone.PhoneTypeID = '1'

AND tblEmployee.FloorID = tblFloor.floorid 
ORDER BY instr('#newOrderList#',',' | Title | ',')
, Fullname;


-paul



-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 9:55 PM
To: CF-Talk
Subject: RE: ORDER BY question


Ok, I'm an idiot... I just thought of a MUCH faster way to do this






SELECT *
FROM myTable
WHERE ID IN (#orderList#) [or whatever here]
ORDER BY instr('#newOrderList#',',' | idColumn | ',')



+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis



-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 6:45 PM
To: CF-Talk
Subject: RE: ORDER BY question


This will do it, but keep a close eye on the processing time of the server,
and make sure if the list gets long that you are using a properly indexed
database.

customTagName.cfm














#preserveSingleQuotes(sqlString)#



notice that in the above you are simply creating a SELECT statement for each
item in the specified SORTORDER list and UNIONing them all together.
I chose UNION ALL because it is faster than UNION... UNION filters out
duplicate rows...


+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 11:59 AM
To: CF-Talk
Subject: ORDER BY question


ok. ASC & DESC don't work on this one.

i want to be able to ORDER BY in a specific order
such as
ORDER BY tblJobTitle.TitleID='25,26,28,4'

is that possible?
if not how else could i do it...




Thanks

-paul




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

nope, didn't do it
thanks Jochem

-paul



-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 8:25 PM
To: CF-Talk
Subject: Re: ORDER BY question


Randell B Adkins wrote:
> Create a new field called Sequence or something.
> Based on the data and the two elements you displayed
> there is no way without Hard-Coding it.

Actually, there is if your database can do a little bit of maths and 
subqueries in the ORDER BY clause. But it is a bit tricky and get's out 
of hand when the number of elements in the list get's too long because 
you need to develop a power series to sort on :)

ORDER BY ( 0

+ (SELECT MAX(TitleID FROM tblJobTitle))^(ListLen(titleIDs) - i) * 
Round(Abs(tblJobTitle.TitleID - i)/(Abs(tblJobTitle.TitleID - i) + 1))
 ) DESC

I doubt this will be usefull IRL, but it should work once you sort out 
the typo's you will inevitably get. Conversion to a stored procedure 
will help as well, you will be able to get the SELECT MAX(TitleID FROM 
tblJobTitle) out of the loop.

Jochem


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

ok...Philip.
how should the parameters go?

i cant find any info on CHARINDEX
in my books.



SELECT  LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as
Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID,
tblEmployee.StudioID, tblEmployee.StatusID, tblEmployee.TitleID,
tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName,
tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb,
tblPhone.PhoneTypeID, tblFloor.floor, tblJobTitle.TitleID, tblJobTitle.Title
FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor, tblJobTitle
WHERE tblEmployee.studioid = tblStudio.studioid
AND tblEmployee.TitleID = tblJobTitle.TitleID 
AND tblOffice.OfficeID = tblStudio.OfficeID
AND tblJobTitle.TitleID IN (25,26,28,4)
AND tblPhone.EmpResID = tblEmployee.EmployeeID
AND tblPhone.PhoneTypeID = '1'

AND tblEmployee.FloorID = tblFloor.floorid 
ORDER BY CHARINDEX('#newOrderList#',',' | tblJobTitle.TitleID | ',')
, Fullname;



-paul



-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 9:04 AM
To: CF-Talk
Subject: RE: ORDER BY question


> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]'instr' is not
> a recognized function name.

INSTR is the Access function - CHARINDEX is the SQL Server one

The parameters are also the other way around

Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911

www.aspmedia.co.uk
www.aspevents.net

An ISO9001 registered company.

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver][SQL Server]The data type int is invalid
for the charindex function. 
Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.




SELECT
LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as Fullname,
tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID,
tblEmployee.StatusID, tblEmployee.TitleID, tblStudio.StudioID,
tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID,
tblOffice.City, tblPhone.PhoneNumb, tblPhone.PhoneTypeID, tblFloor.floor,
tblJobTitle.TitleID, tblJobTitle.Title

FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor, tblJobTitle

WHERE tblEmployee.studioid = tblStudio.studioid
AND tblEmployee.TitleID = tblJobTitle.TitleID 
AND tblOffice.OfficeID = tblStudio.OfficeID
AND tblJobTitle.TitleID IN (25,26,28,4)
AND tblPhone.EmpResID = tblEmployee.EmployeeID
AND tblPhone.PhoneTypeID = '1'
AND tblEmployee.FloorID = tblFloor.floorid 

ORDER BY CHARINDEX(',' + tblJobTitle.TitleID + ',' , '#newOrderList#')



-paul
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ORDER BY question

[Paul Ihrig]

this is odd
if i do this


ORDER BY CHARINDEX(',' + Title + ',' , '#newOrderList#'), Fullname;

it basically doesnt even put in the Title as a Order By Item...

so my group by in the outputs dont work..
oh well.

i can fake this one..
look like a good time to use QaQ

-paul
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: hiermenus

[Paul Ihrig]

This is what i used.
very use full for spnning frames for your nav

http://www.webreference.com/dhtml/column20/

-paul


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JS Question

[Paul Ihrig]

that's similar to what i have in the htm file at the bottom
but it doesn't do it
-paul


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JS Question

[Paul Ihrig]

just paste it into a htm file

- test.htm -




math

function TotalNum_Origionals()  // "this" from below gets passed as "obj"
{
var total = 0;

var amtNum_Origionals = parseFloat(document.all('Num_Origionals').value);
var amtNum_EachSet = parseFloat(document.all('Num_EachSet').value);

if ((! isNaN(amtNum_Origionals)) && (! isNaN(amtNum_EachSet))) {
//once "this" is passed, calculate totals
total = amtNum_Origionals*amtNum_EachSet;
}

document.all('PrintPlotNum').innerHTML = total;
}
function TotalPrintPrice(obj)   // "this" from below gets passed as "obj"
{
var TotalPrintPlotNum = parseFloat(document.all('PrintPlotNum').innerHTML);
var total2 = 0;

if ((! isNaN(TotalPrintPlotNum)) && (obj)) {//once "this" is passed,
calculate totals
amt3 = obj.options[obj.selectedIndex].text; //grabs the text
label instead of the value
total2 = TotalPrintPlotNum*amt3;
}

document.all('PrintPrice').innerHTML = total2;
}   





Num_Origionals



Num_EachSet



Print_Type_ID   


make selection
.10
.20
.50
1.00






Total Number Prints/Plots: PrintPlotNum 0

Total Cost Prints: PrintPrice 2



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JS Question

[Paul Ihrig]

ok
i was able to do this...
seems to work.

but question for you guru's out there.
isn't this kind of Bloated?

shouldn't there be a way to do this with less code?

thanks.
-paul





math

function TotalNum_Origionals(obj)   // "this" from below gets passed as
"obj"
{
var total = 0;

var amtNum_Origionals =
parseFloat(document.all('Num_Origionals').value);
var amtNum_EachSet =
parseFloat(document.all('Num_EachSet').value);

if ((! isNaN(amtNum_Origionals)) && (!
isNaN(amtNum_EachSet))) {   //once "this" is passed, calculate totals
total =
amtNum_Origionals*amtNum_EachSet;
}

document.all('PrintPlotNum').innerHTML = total;
}

function PrintPrice(obj)// "this" from below gets passed as "obj"
{

var total2 = 0;

if ((obj)) {//once "this" is passed,
calculate totals
amt3 =
obj.options[obj.selectedIndex].text;//grabs the text label
instead of the value
PriPri = amt3;
}

document.all('PrintPri').innerHTML = PriPri;
}   

function TotalPrintPrice()  // "this" from below gets passed as "obj"
{
var TotalPrintPlotNum =
parseFloat(document.all('PrintPlotNum').innerHTML);
var TotalPrintPrice =
parseFloat(document.all('PrintPri').innerHTML);

{   //once "this" is passed, calculate
totals

total3 =
TotalPrintPlotNum*TotalPrintPrice;
}

document.all('PrintPrice').innerHTML = total3;
}   





Num_Origionals



Num_EachSet



Print_Type_ID   


0
.10
.20
.50
1.00






Total Number Prints/Plots: PrintPlotNum 0

Total Cost per Print: PrintPrice 0


Total Cost for Prints: PrintPrice 0




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

JS :: Reset Specific field.

[Paul Ihrig]

hello i want to be able to reset specific fields to their default values
based on 
other fields selected

i can reset all the fields in a form by doing this.

but say i only want to reset Print_Type_ID i cant seem to get it to work.

have tried
onClick="document.Print_Type_ID.reset();

but i get 
document.Print_Type_ID is NULL or not an object.

any ideas?

-paul
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JS :: Reset Specific field.

[Paul Ihrig]

got it
objForm.Print_Type_ID.reset();

-paul

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

JS Select Box Value Question :: help

[Paul Ihrig]

Hello
quick question on grabbing a specific result from a select box

Right Now i have this select:


 
   
  
#NumberFormat(rs_Print_Type.Print_Type_Price, '.999')# 
:: #rs_Print_Type.Print_Type_Width#'/
#rs_Print_Type.Print_Type_Height#' 
:: #rs_Print_Type.Print_Type_Color#

 
 

the JS i have:

function PrintPrice(obj)// "this" from below gets passed as "obj"
{
var total2 = 0;

if ((obj)) {//once "this" is passed, calculate totals
amt3 = obj.options[obj.selectedIndex].text; //grabs the text
label instead of the value
PriPri = amt3;
}

document.all('PrintPri').innerHTML = PriPri;
document.all('PrintPri1').value = PriPri;
}   

grabs:
#NumberFormat(rs_Print_Type.Print_Type_Price, '.999')#  ::
#rs_Print_Type.Print_Type_Width#'/ #rs_Print_Type.Print_Type_Height#'  ::
#rs_Print_Type.Print_Type_Color#

form the select box
i want it only to grab #NumberFormat(rs_Print_Type.Print_Type_Price,
'.999')#
the first value.

but want to be able to display the other values.

any ideas?

-paul
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Free to cheap Forum Software

[Paul Ihrig]

hello all.
i know this has been discussed in the past

if you have links to free or cheap
forum or discussion boards i would appreciate it.

thanks

-paul
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

C:/CFusion to D:/CFusion Advice..

[Paul Ihrig]

OK...
i messed up.

i updated cf server on the C Drive.
without having enough space left over for the virus scans & other things to
run..

is there a way to move the
C:/CFusion to D:/CFusion

with out a uninstall & reinstall???

any advice or suggestions would be appreciated.

you can laugh now...
i know i need to rebuild the box, but have no real time or money for it.

thanks.

-paul
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

chart of sorts...

[Paul Ihrig]

ok
i want to create a chart if an employee has filled something out..

LIKE

Employee  Pat   Joe LisaSue
Service 
TriForm  X  X   
CAD X   X   X
DT  X   X   

But using the code below it only seems to display
the first looped record.. and it seems wrong.

LIKE
Employee  Pat   Joe LisaSue
Service 
TriForm X   
CAD X   
DT  X   

Any help on this would be great!
Thanks 

Code Below.
-paul


SELECT DISTINCT Relation_ID, tblRelations.Service_ID,
tblRelations.EmployeeID,  tblService.Service_ID, tblService.Service
FROM tblRelations, tblService
WHERE tblRelations.Service_ID = tblService.Service_ID
ORDER BY Service;



rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;



SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



 
Resource










#LEFT(rsEmployee.FirstName, 1)##rsEmployee.LastName#
 








 
#Trim(myRelations.Service)#












+

-










__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: chart of sorts...

[Paul Ihrig]

any one?
i am trying to do it off 2 queries...
mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 11:53 AM
To: CF-Talk
Subject: chart of sorts...


ok
i want to create a chart if an employee has filled something out..

LIKE

Employee  Pat   Joe LisaSue
Service 
TriForm  X  X   
CAD X   X   X
DT  X   X   

But using the code below it only seems to display
the first looped record.. and it seems wrong.

LIKE
Employee  Pat   Joe LisaSue
Service 
TriForm X   
CAD X   
DT  X   

Any help on this would be great!
Thanks 

Code Below.
-paul


SELECT DISTINCT Relation_ID, tblRelations.Service_ID,
tblRelations.EmployeeID,  tblService.Service_ID, tblService.Service
FROM tblRelations, tblService
WHERE tblRelations.Service_ID = tblService.Service_ID
ORDER BY Service;



rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;



SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



 
Resource










#LEFT(rsEmployee.FirstName, 1)##rsEmployee.LastName#
 








 
#Trim(myRelations.Service)#












+

-











__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Devcon Volunteers

[Paul Ihrig]

any one know if MM has any programs for volunteers?
for setting up/tearing down & such...

looks like my Co. wont pay for any training or conferences..

so would like to figure out other options to get in & learn...

maybe i can grow a beard by then & sneak in
joke

:]

-paul
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: breaking a loop... need help

[Paul Ihrig]

Bud --- 
i pasted your code here
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid05.cfm

at the bottom of the page...
still no luck..

-paul
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help Displaying results that loop

[Paul Ihrig]

ok came into the office to try it out...
mucked about a bit...

and wasn't able to float it...
Isaac you can see a your modified example here...
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid06.cfm

im going home now..
bringing my laptop to hopefully get this working this weekend..

thanks again
-paul


SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



SELECT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID,
tblService.Service_ID, tblService.Service,  tblEmployee.EmployeeID,
LastName, FirstName
FROM tblRelations, tblService, tblEmployee
WHERE tblRelations.Service_ID = tblService.Service_ID
AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID)
ORDER BY Service, LastName;


SELECT tblRelations.Relation_ID, tblRelations.Service_ID,
tblRelations.EmployeeID, tblService.Service_ID, tblService.Service,
tblEmployee.EmployeeID, tblEmployee.LastName, tblEmployee.FirstName
FROM (tblRelations LEFT JOIN tblService ON tblService.Service_ID =
tblRelations.Service_ID)
INNER JOIN tblEmployee ON tblEmployee.EmployeeID IN
(tblRelations.EmployeeID) 




rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;



   
Service
  
 
  
  #LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName,
1)#.
  #rsEmployee.EmployeeID#
  
 
  
  



 
 
  #Trim(myRelations.Service)#
  
  
  #myRelations.EmployeeID#
  
  


 





#rsEmployee.EmployeeID#

#rsEmployee.EmployeeID#




  
  
   
 
   

  



Isaac Dealey [code]


#Service#

#EmployeeID#   


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: breaking a loop... need help

[Paul Ihrig]

this is as close as i can get...
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid07.cfm
not quiet there..
i know it has to be something relatively simple!

any more help would be fantastic!

-paul



SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



SELECT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID,
tblService.Service_ID, tblService.Service,  tblEmployee.EmployeeID,
LastName, FirstName
FROM tblRelations, tblService, tblEmployee
WHERE tblRelations.Service_ID = tblService.Service_ID
AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID)
ORDER BY Service, LastName;


rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;



 
Service

 

#LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName, 1)#.
#rsEmployee.EmployeeID#

 




 
#Trim(myRelations.Service)#


#myRelations.EmployeeID#




#EmployeeID# 


 

#EmployeeID#




 
  
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

INNER JOIN

[Paul Ihrig]

can you see whats wrong with this query?
error below
thanks
-paul


SELECT tblRelations.Relation_ID,
tblService.Service_ID, tblService.Service,
tblEmployee.EmployeeID,
LEFT(LTRIM(tblEmployee.LastName),1) + '.' +
LEFT(LTRIM(tblEmployee.FirstName),1) + '.' AS
employeeinitial

FROM tblService
INNER JOIN tblEmployee ON ( tblEmployee.EmployeeID IS NOT NULL )
LEFT JOIN tblRelations ON (
tblRelations.EmployeeID = tblEmployee.EmployeeID AND
tblRelations.Service_ID = tblService.ServiceID )
WHERE EXISTS (SELECT EmployeeID FROM tblRelations
WHERE tblRelations.EmployeeID = tblEmployee.EmployeeID)
ORDER BY tblService.Service, tblEmployee.LastName,
tblEmployee.Firstname



[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression
'( tblEmployee.EmployeeID NOT NULL ) LEFT JOIN tblRelations ON (
tblRelations.EmployeeID = tblEmployee.EmployeeID AND tblRelations.Service_ID
= tblService.ServiceID )'.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (2:51).
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: breaking a loop... need help

[Paul Ihrig]

still need help!
thx
-paul
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: breaking a loop... need help

[Paul Ihrig]

Thanks To:
Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

I really do appreciate the great help i have recieved here...
The code that did it!

-paul


SELECT DISTINCT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



SELECT DISTINCT Relation_ID, tblRelations.Service_ID,
tblRelations.EmployeeID,  tblService.Service_ID, tblService.Service,
tblEmployee.EmployeeID, LastName, FirstName
FROM tblRelations, tblService, tblEmployee
WHERE tblRelations.Service_ID = tblService.Service_ID
AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID)
ORDER BY Service, LastName;


rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;






Untitled






Resource


#LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName, 1)#.
#rsEmployee.EmployeeID#











#Trim(myRelations.Service)#



#rsEmployee.EmployeeID#

#rsEmployee.EmployeeID#












__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Law Suit

[Paul Ihrig]

you  can stiull save document as
: ]

> -Original Message-
> From: Chapman, Katrina [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 8:12 PM
> To:   CF-Talk
> Subject:  RE: Law Suit
> 
> It soo silly.  If you go to
> 
> http://www.milberg.com/allaire/complaint.html
> 
> And try to right click or make any keystroke while in the window you'll
> get
> a message that says:
> 
> "This document may not be downloaded.
> It may be viewed by clicking on the scroll bar, on the right side of your
> screen.
> If you would like a hard copy of this complaint, please contact Milberg
> Weiss at (800) 320-5081."
> 
> Silly, silly fool developer.  They don't know about turning off JS or
> clicking on View/Source to get it.  
> 
> Think someone should tell them?
> 
> --K 
> 
> > -Original Message-
> > From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 25, 2000 5:05 PM
> > To: CF-Talk
> > Subject: RE: Law Suit
> > 
> > 
> > (Could' resit the temptation.)
> > 
> > Should that be Explain this to the 
> > shareholders
> > 
> > 
> > 
> > Kevin Parker
> > Service and Communication
> > WorkCover Corporation
> > 
> > [EMAIL PROTECTED]
> > 
> > ph:  +61 8 82332548
> > fax: +61 8 82332000
> > 
> > 
> > 
> > -Original Message-
> > From: John Morgan [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 26 September 2000 7:14:AM
> > To: CF-Talk
> > Subject: Law Suit
> > 
> > 
> > Looks like Allaire has a new freshly pressed suit...
> > 
> > a law suit!
> > 
> > http://biz.yahoo.com/bw/000925/ny_milberg.html
> > 
> > 
> > --
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> 
> 
> **
> **
> This e-mail is intended for the use of the addressee only. It may contain
> information that is protected by legislated confidentiality and/or is
> legally privileged. If you are not the intended recipient you are
> prohibited
> from disseminating, distributing or copying this e-mail. Any opinion
> expressed in this e-mail may not necessarily be that of the WorkCover
> Corporation of South Australia. Although precautions have been taken, the
> sender cannot warrant that this e-mail or any files transmitted with it
> are
> free of viruses or any other defect.
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and destroy the original e-mail and any
> copies.
> **
> **
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF-Stock :: is the list up?

[Paul Ihrig]

is CF-stock up?
i just signed up & have some questions!

i just made my first stock purchase ever!
of ALLR : ]

never thought i would do the capitalist thing!
but then again i never thought i would do any back end development either!

& to think 4 years ago all i cared about was painting in oils!

life is to weird sometimes!

-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

WaySimple :: Cursor, from i-bar to color cube? ::

[Paul Ihrig]

ok, installed the sp 2.
now my cursor is a color cube instead oif the | bar.

i know this is too simple for the list, but i cant find the correct
preferance!

thanks.
-paul

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Cursor problems: Was; WaySimple :: Cursor, from i-bar to color cube? ::

[Paul Ihrig]

how do i get the cursor back to a bar instead of highlighted selected
character?
thanks
-paul

> -Original Message-
> From: Paul Ihrig [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 03, 2000 3:07 PM
> To:   CF-Talk
> Subject:  WaySimple :: Cursor, from i-bar to color cube? :: 
> 
> ok, installed the sp 2.
> now my cursor is a color cube instead oif the | bar.
> 
> i know this is too simple for the list, but i cant find the correct
> preferance!
> 
> thanks.
> -paul
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cursor problems: Was; WaySimple :: Cursor, from i-bar to col or c ube? ::

[Paul Ihrig]

thanks you David Hayes & Dave Watts!
man o man!

-paul

> -Original Message-
> From: Hayes, David [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 03, 2000 4:16 PM
> To:   CF-Talk
> Subject:  RE: Cursor problems: Was;  WaySimple :: Cursor, from i-bar
> to col or c ube? :: 
> 
> umm...I think that's the "insert" key on the keyboard.   We all have
> such days.
> 
> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 03, 2000 2:59 PM
> To: CF-Talk
> Subject: Cursor problems: Was; WaySimple :: Cursor, from i-bar to color
> c ube? :: 
> 
> 
> how do i get the cursor back to a bar instead of highlighted selected
> character?
> thanks
> -paul
> 
> > -Original Message-
> > From:   Paul Ihrig [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, October 03, 2000 3:07 PM
> > To: CF-Talk
> > Subject:WaySimple :: Cursor, from i-bar to color cube? :: 
> > 
> > ok, installed the sp 2.
> > now my cursor is a color cube instead oif the | bar.
> > 
> > i know this is too simple for the list, but i cant find the correct
> > preferance!
> > 
> > thanks.
> > -paul
> > 
> >
> --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > the body.
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Graphic Rollovers without Javascript

[Paul Ihrig]

User Flash

: ]

> -Original Message-
> From: Scott, Andrew [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 02, 2000 11:31 PM
> To:   CF-Talk
> Subject:  RE: Graphic Rollovers without Javascript
> 
> Rule #1 - Javascript is Client Side scripting, Coldfusion is server side
> scripting.
> 
> With this rule in mind, how would you propose to tell the browser to
> change
> the image when someone rolled over it. For this to happen the browser
> would
> have to request the page again from the server everytime. Now if this was
> possible there would still need JS to tell the page to refresh, NO its not
> possilbe without JS:-)
> 
> 
> 
> regards
> 
> Andrew Scott
> ANZ eCommerce Centre
> * Ph 9273 0693  
> * [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Powers, Bonnie [mailto:[EMAIL PROTECTED]]
> Sent: 02 October 2000 23:42
> To: CF-Talk
> Subject: Graphic Rollovers without Javascript
> 
> 
> I would like to do graphic rollovers on my website without using
> javascript.
> Does anyone know of any ColdFusion applications and/or custom tags which
> can
> help me do this.  I have visited the Allaire Developers Gallery, but most
> of
> those apps use Javascript with ColdFusion.
> 
> Thanks in Advance,
> Bonnie
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Mail list question :: CFmail & Exchange.

[Paul Ihrig]

hello.
if i use a form using cfmail
can i have the to field use a mail list on the exchange server?
Studio 1 Columbus




thanks

-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Conference - unofficial list of attendees

[Paul Ihrig]

Error Occurred While Processing Request
Error Diagnostic Information Just in time compilation error  unknown parser
error  The last successfully parsed CFML construct was the CFML template
beginning occupying document position (1:1) to (1:1).  The specific sequence
of files included or processed is:
C:\Inetpub\cfm-resources.com\web\members\dshadovi\AddEntry.cfm  Date/Time:
10/04/00 09:04:31 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT;
AIT) Remote Address: 63.69.175.69 HTTP Referer:
http://www.cfm-resources.com/members/dshadovi/index.html



> -Original Message-
> From: David Shadovitz [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, September 29, 2000 4:57 PM
> To:   CF-Talk
> Subject:  Conference - unofficial list of attendees
> 
> Friends,
> 
> I greatly enjoy this email forum, and I look forward to meeting those of
> you who'll be at the Allaire Developer Conference.  To abet this, I
> created a simple signup page at
> www.cfm-resources.com/members/dshadovi/index.html.  I invite all
> attendees to sign up.  Then we'll all know whom to expect.
> 
> (As many of you know, the CFM Resources server is often down.  Sorry if
> the site is hard to get to.)
> 
> -David
> 
> YOU'RE PAYING TOO MUCH FOR THE INTERNET!
> Juno now offers FREE Internet Access!
> Try it today - there's no risk!  For your FREE software, visit:
> http://dl.www.juno.com/get/tagj.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: OT: Video format

[Paul Ihrig]

i am very happy with or Matrox DigiSuit.
you can get the card for around
 <<...OLE_Obj...>> 

very good quality, mid to high end.
plenty of effects.
-paul

> -Original Message-
> From: Richard Ramos [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 03, 2000 2:27 PM
> To:   CF-Talk
> Subject:  Re: OT: Video format
> 
> You need to have a capture card installed on your machine.  We use
> Broadway
> cards, but they cost $700 a pop.  I would recommend the Osprey 200 card
> from
> Viewcast.  They cost about $200 each, I believe.  Check their website to
> be
> sure.  Also, Winnov Videum, I think it works with both Real and Windows
> Media, $200? a pop.  There are other cards probably for cheaper, but these
> are very good quality cards for the price.
> 
> Richard Ramos
> Network Administrator
> Softitler Net, Inc.
> www.softitler.com
> [EMAIL PROTECTED]
> 
> - Original Message -
> From: "paul smith" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 03, 2000 10:50 AM
> Subject: Re: OT: Video format
> 
> 
> > How do you get the video from tape to digital?
> >
> > best,  paul
> >
> > At 12:46 PM 10/3/00 -0400, you wrote:
> > >You must use their "Real Producer" which is also free (or Media Cleaner
> > >Pro which is not) to convert a video to the Real Format.
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Realsim and 4D Arrays

[Paul Ihrig]

imagine the tardis.
with Dr. Who flying through space & time.
3-demensional on the out side, but infinite within.

just messing.
-paul

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 06, 2000 8:07 AM
> To:   CF-Talk
> Subject:  Re: Realsim and 4D Arrays
> 
> How about a cube moving thru time ... then each one of those little cubes 
> would have x,y,z at any giving point in time. The cube with a velocity
> moving 
> thru time ... yeap, I think that'll do it.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF Script

[Paul Ihrig]

hello all!
what is a good referance to learn CF_Script?
What URL's do you have?

i would like to know why you would or would not use it.
what are its benifits?

i have noticed that Ultra_Dev uses it alot in its pages.

Thank You.
-paul
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Once In A Lifetime Photo

[Paul Ihrig]

friggin incredible!
my fiance sent that to me a few days ago.

i couldnt imagine.
going camping in 2 weeks!

> -Original Message-
> From: Dave Hannum [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 06, 2000 9:24 AM
> To:   CF-Talk
> Subject:  OT:  Once In A Lifetime Photo
> 
> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0012_01C02F77.2AAD7B80
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> 
> You have got to see this.  The caption below the photo explains all.
> 
> Enjoy,
> Dave
> 
>  http://www.boortz.com/FireElk.htm
> 
> --=_NextPart_000_0012_01C02F77.2AAD7B80
> Content-Type: application/octet-stream;
>   name="FireElk.url"
> Content-Transfer-Encoding: 7bit
> Content-Disposition: attachment;
>   filename="FireElk.url"
> 
> [DEFAULT]
> BASEURL=http://www.boortz.com/FireElk.htm
> [InternetShortcut]
> URL=http://www.boortz.com/FireElk.htm
> Modified=00CE3955982FC001E4
> 
> --=_NextPart_000_0012_01C02F77.2AAD7B80--
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Realsim and 4D Arrays

[Paul Ihrig]

http://206.183.250.42/flash/bwCubes.swf

> -Original Message-
> From: Gavin Myers [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 06, 2000 8:49 AM
> To:   CF-Talk
> Subject:  Realsim and 4D Arrays
> 
> 
> 
> Maybe its because I don't exist in some Sci-Fi Channel tv show, but I'm
> having a hard time thinking of what a 4D Array looks like.
> 
> 1d = X cordinate
> 2d = X,Y cordinate
> 3d = X,Y,Z cordinate
> 4d = bah!
> 
> Considering a 1d array is a line, a 2d is a plane, 3d is a cube, would 4d
> then in this sense, be 1 cube seperated by several smaller cubes wich are
> in
> turn seperated by even smaller cubes?
> 
> or is it just not safe to go there?
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Check out CF_Challenge!

[Paul Ihrig]

Scott, Great Idea!

looks like this site will be popular!
best of luck.
-paul

> -Original Message-
> From: Neil H. [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, October 07, 2000 1:36 AM
> To:   CF-Talk
> Subject:  Re: Check out CF_Challenge!
> 
> Very Cool Idea.  I like that :)
> 
> Neil
> 
> - Original Message -
> From: "Scott Knaub" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, October 07, 2000 1:25 AM
> Subject: Check out CF_Challenge!
> 
> 
> > There is a new Web site that is dedicated to helping the newcomers to
> ColdFusion. Inspired by everyone who has ever asked me to help them learn
> ColdFusion, I have set up a Web site to help those who want to learn and
> get
> some experience.
> >
> > Here's the place to hone your CF skills:
> http://www.cfm-resources.com/members/CF_Challenge/
> >
> > CF_Challenge will present scenarios that need a CF solution. You write
> your CF template(s), test your solution and submit it for review and
> critique by experienced ColdFusion developers.
> >
> > You learn in three ways:
> > 1. By writing your CF code to solve the challenge
> > 2. By seeing how other developers have solved the challenge
> > 3. By reviewing comments from other ColdFusion developers
> >
> > I hope you like it...Enjoy!
> > Scott
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: catching 3 filenames when using cffile :: some source code

[Paul Ihrig]

here is some code that i was given great help on.

the form::

SELECT * 
FROM tbl_File





SELECT * FROM tbl_File
WHERE FileID = #set_FileID#



 













  
 
   
Image 
  File Info: 
  You can upload up to 3 (*.jpg or *.gif)
images.
  

 
  Upload Image 1:
   

  
 

  
  
  

  


 
 
  Caption 1:
   

  

#File_Type.Caption1#
 
  
  
  

  

 
  Upload Image 2:
   

  
 

  
  
  

  

   


 
  Caption 2:
   

  

#File_Type.Caption2#
 
  
  
  

  

 
  Upload Image 3:
   

  
 

  
  
  

 

   


 
  Caption 3:
   

  

#File_Type.Caption3#
 
  
  
  

  

   
 
  

 
  
  
   

  

 
  


  
















SELECT Max(ContactID) AS MaxOfContactID
FROM tbl_Contact;









SELECT Max(ContactID) AS MaxOfContactID
FROM tbl_Contact;




INSERT INTO tbl_Issue(CategoryTypeID,
AuthorID, SoftwareID, Description, Version, IssueName, Keywords, CreateDate)
VALUES(#CategoryTypeID#,
#GetID.MaxOfContactID#, '#SoftwareID#', '#FORM.Description#',
'#FORM.Version#', '#FORM.IssueName#', '#FORM.Keywords#',
'#FORM.CreateDate#');






 SELECT Max(IssueID) AS MaxOfIssueID
 FROM tbl_Issue;




SELECT c.CategoryTypeName, s.SoftwareName
FROM tbl_CategoryType c, tbl_Software s
WHERE c.CategoryTypeID = #CategoryTypeID#
AND s.SoftwareID = #SoftwareID#;




User - Input









Knowledge Base Data Entered



The Issue:
#Form.IssueName#
   

Description:

#ParagraphFormat(Form.Description)#


Category:
#CategoryTypeName#


Keywords:
#Form.Keywords#


Date Opened:
#Form.CreateDate#
   

Author:
#Form.FirstName#
#Form.LastName#


Email:
mailto:#FORM.Email#">
#Form.Email#


Phone Extension:
#Form.PhoneExt#



Last Updated:
#Fo

RE: Anyone know how to stay awake after overnighters??

[Paul Ihrig]

I always enjoyed close pins on the nipples, while inhaling bleach fumes.
ogh, sorry wrong list

> -Original Message-
> From: Russel Madere [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 10, 2000 1:46 PM
> To:   CF-Talk
> Subject:  RE: Anyone know how to stay awake after overnighters??
> 
> Thanks for those words of encouragement!
> 
> Now I don't think I'll sleep for a month.
> 
> Russel
> 
> 
>   Russel Madere, Jr. Senior Web Developer
>   ICQ: 5446158   http://www.TurboSquid.com
> 
> Some days you eat the bear; some days the bear eats you.
> 
> 
> 
> -Original Message-
> From: Jaime Garza [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 10, 2000 12:27
> To: CF-Talk
> Subject: RE: Anyone know how to stay awake after overnighters??
> 
> 
> Don't worry, the product is out.  The PRODUCT IS OUT! Isn't that scary?
> What if your customer finds a SHOW STOPPER in the first minute?  Is that
> bug
> REALLY fixed and gone?
> 
> That'll keep you awake.  Feels good being of service...
> 
> 
> 
> 
> 
> > -Original Message-
> > From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 10, 2000 7:28 AM
> > To: CF-Talk
> > Subject: Anyone know how to stay awake after overnighters??
> >
> >
> > After a very long night we got a product out the door? Now
> > another work day.
> > Anyone have any pointers
> >
> > -Brian
> >
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: OT Web Site Map Generator

[Paul Ihrig]

DreamWeaver & Ultra-Dev have a pretty good Site Map.
The only thing i dont like about it is that you cant print it unless you
first do a screen shot.

-paul

> -Original Message-
> From: Evan Lavidor [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 9:44 AM
> To:   CF-Talk
> Subject:  RE: OT Web Site Map Generator
> 
> I've used Visio and it works with .cfm's fine.  You have to add it to the
> list - it doesn't support it "out of the box."  However, on anything
> larger
> than "small" sites, I think visio doesn't do a good job.
> 
> Evan
> 
> > -Original Message-
> > From: David Shadovitz [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 12, 2000 9:16 AM
> > To: CF-Talk
> > Subject: Re: OT Web Site Map Generator
> >
> >
> > Visio does this, although it cannot traverse CFM pages.  (It does handle
> > ASP, though.)
> > -David
> >
> > On Thu, 12 Oct 2000 06:01:00 -0700 Dick Applebaum <[EMAIL PROTECTED]>
> > writes:
> > > Can anyone recommend a web "site map" generator?  I am looking for a
> > > tool which will help analyze the design and paths through existing
> > > sites.
> > >
> > > The goal of the analysis is to improve the usability of the sites.
> > >
> > > TIA
> > >
> > > Dick
> > 
> > YOU'RE PAYING TOO MUCH FOR THE INTERNET!
> > Juno now offers FREE Internet Access!
> > Try it today - there's no risk!  For your FREE software, visit:
> > http://dl.www.juno.com/get/tagj.
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

this should be simple but it isnt.
to be able to pull up the surounding framesets on out intranet i was helped
to put a few cfparams in my default frame set.

now i would like to be able to email an inhouse link like below, going to a
specific anchor in a specific frameset.

http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggraph9
9Notes.htm#course6

but the anchores dont seem to work this way.
any ideas?

can it be done.

do i need a &? befor the #course6
do i need to define the # in my main default.cfm frame set.

please dont laugh too hard.

-paul

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

nope that didnt work.
http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggraph9
9Notes.htm##course6
any other ideas?
thank you 
-paul


> -Original Message-
> From: Nardi, Gaston [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, October 18, 2000 4:26 PM
> To:   CF-Talk
> Subject:  RE: Cfparam :: FrameSets :: & Anchors oh my!
> 
> Maybe you should scape the # in your link with another #, like this:
> 
>   
> http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggrap
> h9
> 9Notes.htm##course6
> 
> 
> Hope this help you.
> 
> Gaston.
> 
> 
> > -Mensaje original-
> > De: Paul Ihrig [SMTP:[EMAIL PROTECTED]]
> > Enviado el: Miércoles 18 de Octubre de 2000 17:14
> > Para:   CF-Talk
> > Asunto: Cfparam :: FrameSets :: & Anchors oh my!
> > 
> > this should be simple but it isnt.
> > to be able to pull up the surounding framesets on out intranet i was
> > helped
> > to put a few cfparams in my default frame set.
> > 
> > now i would like to be able to email an inhouse link like below, going
> to
> > a
> > specific anchor in a specific frameset.
> > 
> >
> http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggrap
> > h9
> > 9Notes.htm#course6
> > 
> > but the anchores dont seem to work this way.
> > any ideas?
> > 
> > can it be done.
> > 
> > do i need a &? befor the #course6
> > do i need to define the # in my main default.cfm frame set.
> > 
> > please dont laugh too hard.
> > 
> > -paul
> >
> --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send
> > a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

Philip, thanks, but i didnt work.
here is my default frameset.
---




 



   



 
 
  
-
the example you gave me just returned a 404.

again thank you.

-paul

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

nope that didn't work either.
and yes this is what i have for a link in the targeted frame.

Course #6: Fundamental Issues of Visual Perception for
Effective Image Generation


targeting



any other ideas?

again thank you

-paul




> -Original Message-
> From: Stephen Moretti [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 23, 2000 9:27 AM
> To:   CF-Talk
> Subject:  RE: Cfparam :: FrameSets :: & Anchors oh my!
> 
> Paul,
> 
> >
> >
> >
> http://inhouse/default.cfm?MainPage=DesignTech/technews/Siggraph99/siggrap
> h9
> 9Notes.htm#course6
> >
> 
> Daft question, but are you putting/generating the 
> into your html page, so that the browser knows where to go when you give
> it
> an anchor name??
> 
> If you are, have you tried :
> 
> http://inhouse/default.cfm#course6?MainPage=DesignTech/technews/Siggraph99
> /s
> iggraph99Notes.htm
> 
> I'm not entirely convinced that this will work, but give it a go
> 
> Regards
> 
> Stephen
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

thanks.

so sending an email link, to users on our intranet that would pull
up the frame sets & the target anchor wont work?
thanks again
-paul

> If, from the URL you gave us in your first email, default.cfm is the
> frameset, from which the above comes, then the anchor will never work, as
> your browser will look for course6 in default.cfm and not in the MainPage
> that you specify.
> 
> I think the only way that you will get this to work is if you actually
> target the page to the frame, so that you will open
> "DesignTech/technews/Siggraph99/siggraph99Notes.htm#course6" in your frame
> "MainPage" rather than re-openning all of the frames from the top of your
> browser window via default.cfm.
> 
> Hope this helps
> 
> Regards
> 
> Stephen
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Awards

[Paul Ihrig]

i would like to nominate Mike Grundivig, for his continued patience! 
: ]
And also Stephen Moretti, JJ Frausto, & CF_Scott for thier help as well.

thanks again

-paul 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

Stephen.
i tried that but i recieved this error
thanks

-paul


--\
Error Occurred While Processing Request
Error Diagnostic Information Just in time compilation error  Invalid parser
construct found on line 27 at position 39. ColdFusion was looking at the
following text:url.courseidInvalid expression format. The usual cause is an
error in the expression structure.  The last successfully parsed CFML
construct was a CFSET tag occupying document position (27:2) to (27:7).  The
specific sequence of files included or processed is:
D:\www\inhouse\default.cfm  Date/Time: 10/23/00 14:51:06 Browser:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT; AIT) Remote Address:
10.101.4.26 Query String:
MainPage=DesignTech/technews/Siggraph99/siggraph99Notes.htm&courseID=course6


-\

this is what the default page looked like.

-\








Welcome to NBBJ






 



   











 
  


  
  
  



  
  




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Cfparam :: FrameSets :: & Anchors oh my!

[Paul Ihrig]

it worked great!
thanks a ton!
really do appreciate the help

-paul

> -Original Message-
> From: Stephen Moretti [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 4:48 AM
> To:   CF-Talk
> Cc:   [EMAIL PROTECTED]
> Subject:  RE: Cfparam :: FrameSets :: & Anchors oh my!
> 
> Morning Paul,
> >
> > i tried that but i recieved this error
> > thanks
> >
> Sorry about that.
> 
> I accidently sent the untested version.  This is what the  should
> look
> like
> 
> 
> 
>   
> 
> 
> I made a mess of the ! :o}  Too many "'s and not enough &. ;o)
> 
> Regards
> 
> Stephen
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Who's going to NYC this week?

[Paul Ihrig]

nope!
no budget.
just squeaked by getting to go to the dev conference in D.C.
-paul

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

a simple app works for me, but throughs my manager errors?

[Paul Ihrig]

ok, i have a very simple little app i through together for our education
section of our intranet.
the admin can create a program, upload an image.
then create a class & description.
then create a calendar, where the classes can be reused by different
instructors on different dates & such.

every thing seems to work great on my NT laptop, pointing to out production
server.
but when my manager goes to the same pages, he get all types of errors like
the one below.
when i do the same thing, i don't get the errors & the app does what it
should!

Could it be his browser, or something to do with his cache?

i know he copies my pages from our server to his local machine almost
nightly, for what i don't know.

but could his computer be crossing old pages with my new ones?

any advice would be great.
i am pretty sure, all my pages work correctly.

again thank you.

-paul

Error Occurred While Processing Request
Error Diagnostic Information An error occurred while evaluating the
expression:  #Form.ProgramID# Error near line 4, column 18.   Error
resolving parameter FORM.PROGRAMID  The specified form field cannot be
found. This problem is very likely due to the fact that you have misspelled
the form field name.  The error occurred while processing an element with a
general identifier of (#Form.ProgramID#), occupying document position (4:17)
to (4:32). Date/Time: 10/25/00 18:04:17 Browser: Mozilla/4.0 (compatible;
MSIE 5.0; Windows NT; DigExt) Remote Address: 10.101.4.181 HTTP Referer:
http://inhouse/education/AdminPages/Program/Program_Photo2.cfm?ProgramID=44,
http://inhouse/education/AdminPages/Program/Program_Photo2.cfm?ProgramID=44

Please inform the site administrator  that this
error has occurred (be sure to include the contents of this page in your
message to the administrator). 


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: a simple app works for me, but throughs my manager errors?

[Paul Ihrig]

Deanna.
yeh that might be it.
but why would he get the error & not myself?
we are bboth pointing to the production server.

could it be a conflict in his PWS?
say if he copied some of the older pages to his local server?

i wil goofe around with his laptop when i have some time, & see what can be
figured out.

-paul

> -Original Message-
> From: Deanna L. Schneider [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 26, 2000 9:09 AM
> To:   CF-Talk
> Subject:  Re: a simple app works for me, but throughs my manager
> errors?
> 
> Off the top of my head, it looks like you're passing the programid as a
> url
> variable, not a form variable.
> 
> Although I'm not sure why that would work locally
> 
> 
> 
> 
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
> 
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: a simple app works for me, but throughs my manager errors?

[Paul Ihrig]

i sent you the code.
hope it wasnt too much.

thanks
-paul

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: An Idea about access and paragraphs

[Paul Ihrig]

hey man.
where you designning for netscape?
i noticed a 1 pixel differance in you alignment.
i am on ie5.5

just thought i would let you know
-paul

> -Original Message-
> From: Mark Smeets [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 4:42 PM
> To:   CF-Talk
> Subject:  Re: An Idea about access and paragraphs
> 
> Hi all,
> 
> Well, I had my prayers answered as far as the paragraph issues goes 
> (currently jumping up and down in my chair). A HUGE thanks to everyone who
> 
> posted, and also Mark Warrick (who pretty much pointed me to the answer)
> 
> Here's the result, I'll leave this story posted for a while. As you can
> see 
> it formats normally.
> 
> http://24.113.34.178/op1999/index.cfm
> 
> The actual code I used was this
> 
> ", "ALL")#">
> 
> Followed by a regular sql statement. (of course you have the other bits
> and 
> pieces in there)
> 
> Text1 (I didn't know that Text was a reserved word until one late late 
> night) is the field in the database. But this is great, no more relying on
> 
> the user to enter a  at each line.
> 
> Mark Smeets/stranger0/ICQ #1062196
> 
> "Mr. West, not every situation requires your patented approach of shoot 
> first, shoot later, shoot some more and then when everybody's dead try to 
> ask a question or two" - Wild Wild West
> 
> Official Splitting Adam Homepage
> http://www.splittingadam.com/
> 
> Over the Wall Productions and Web Designs
> http://www.solarcourt.com/
> 
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at 
> http://profiles.msn.com.
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: semi-OT: picture, this is too cool

[Paul Ihrig]

ok, i knew i should have registered for the underground.
or did i?
http://www.cfconf.com/cf_underground/
is full!

if any one cancels let me know.
i will be in DC on sat-wens.

if not, can you leave me a glass at the Marriott Wardman Park Hotel
concierge.
: ]

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534

Home:   [EMAIL PROTECTED]
614 449-1681

[EMAIL PROTECTED]
icq:47658358


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: conference info

[Paul Ihrig]

yes but who is signed up?
was there a comfirmation?

> -Original Message-
> From: Nathan Stanford [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 31, 2000 9:50 AM
> To:   CF-Talk
> Subject:  RE: conference info
> 
> 
> CF_Underground
> http://www.cftipsplus.com/CF_UnderGround/cf_underground.cfm
> 
> http://www.cfconf.com/cf_underground/
> 
> http://www.fusionauthority.com/
> 
> 
> CF_Scale
> https://secure.teratech.com/cfscale/cfscalereg.cfm
> 
> 
> Sorry CF_Underground is FULL the fire marshall will only allow us the
> number
> we already have signed up.
> 
> 
> 
> > -Original Message-
> > From:   Kevin Schmidt [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, October 31, 2000 9:35 AM
> > To: CF-Talk
> > Subject:ot:  conference info
> > 
> > I am headed to the developers conference on Saturday and have noticed in
> > various posts things like CF_Underground and CF_Scale and CF_Beer.
> > Anybody
> > got more info on these. Location? Time? Date? Etc
> > 
> > Thanks,
> > 
> > Kevin Schmidt
> > Internet Services Director
> > PWB Integrated Marketing and Communications
> > Office: 734.995.5000
> > Mobile: 734.649.4843
> > 
> > 
> > 
> >
> --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send
> > a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]