Re: running administrator in a coldfusion multiserver environment

[Peter Tanswell]

I still cant get it working !!!

On Thu, Mar 27, 2008 at 3:08 PM, Toby King <[EMAIL PROTECTED]> wrote:

> Hi there
>
> I have been rebuilding a server and decided as I had the opportunity and
> the resources this time that I would set up the server with the following
> configuration:
>
> Apache 2.2
> ColdFusion v7 (Multiserver) - I do have v8 but only standard.
>
> I have installed Apache and I have also installed CF7.
>
> But I am unable to browse to the administrator page.
>
> I believe everything installed correctly - basically I have the following:
>
> c:/jrun4 with various subfolders
>
> c:/program files/apache/htdocs/cfide/administrator
>
> Everytime I try to browse to
> http://127.0.0.1/cfide/administrator/index.cfm I get a message File
> Download - Do you want to open or save this file?
>
> This is getting frustrating - I must just be missing something somewhere
> but I cant see what it is?
>
> Regards & thanks in advance.
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302153
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Installing CF7 Multiserver configuration

[Peter Tanswell]

Hi there

I have been rebuilding a server and decided as I had the opportunity and the
resources this time that I would set up the server with the following
configuration:

Apache 2.2
ColdFusion v7 (Multiserver) - I do have v8 but only standard.

I have installed Apache and I have also installed CF7.

But I am unable to browse to the administrator page.

I believe everything installed correctly - basically I have the following:

c:/jrun4 with various subfolders

c:/program files/apache/htdocs/cfide/administrator

Everytime I try to browse to
http://127.0.0.1/cfide/administrator/index.cfmI get a message File
Download - Do you want to open or save this file?

This is getting frustrating - I must just be missing something somewhere but
I cant see what it is?
Regards & thanks in advance.

(Sorry if this gets posted twice)

Appreciate any tips I receive


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302130
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Handling multiple selection

[Peter Tanswell]

yes thats what I meant - I'm struggling with looping over the list.




On Fri, Mar 14, 2008 at 4:47 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:

> what do you mean by 'handling'? are you referring to the form's action
> page?
>
> multi-select list passes a coma-delimited list of selected items' values
> to the action page. you may have to adjust your action page code to loop
> over this list and perform necessary actions...
>
> Azadi Saryev
> Sabai-dee.com <http://sabai-dee.com/>
> http://www.sabai-dee.com/
>
>
>
> Peter Tanswell wrote:
> > Hi Azadi
> >
> >
> > That works but if a user selects 2 employees, it is only handling the
> first
> > id.
> >
> > Thanks
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301233
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Handling multiple selection

[Peter Tanswell]

Hi Azadi


That works but if a user selects 2 employees, it is only handling the first
id.

Thanks



On Fri, Mar 14, 2008 at 4:19 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:

> WHERE empid IN ( cfsqltype="cf_sql_varchar">)
>
> hth
>
> Azadi Saryev
> Sabai-dee.com 
> http://www.sabai-dee.com/
>
>
>
> Toby King wrote:
> > Hi there
> >
> > I am developing a form for an organisation for their HR section to
> report on superannuation contributions etc.
> >
> > HR want to be able to select 1 or more staff members to report on at any
> one time.
> >
> > I have a list/menu in the form where a user can select 1 or more names
> to report on.
> >
> > After a user fills in the form I pass them to a confirmation screen to
> allow them to either proceed or return to the form to make amendments.
> >
> > If a user selects only one prson everything works fine when displaying
> the names.  If 2 or more people are selected the names are not displayed.
> >
> > >From the selection form I am passing over multiple empids in the
> format, 3173B704-19-02-08,E6A2E4D1-05-02-08 (just shown are 2 empids.
> >
> > Now in the confirmation screen I have a query
> >
> >
> >  SELECT  * FROM  tbl_employees WHERE  empid = '#form.empid#'
> >
> >
> > How do I handle this - I am guessing I will have to do an unstring or
> something
> >
> > Thanks in advance.
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301231
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: fixing a piece of code

[Peter Tanswell]

OK - that made a difference


I'm now getting the following:

   Variable GIRLS is undefined. The error occurred in *C:\Program
Files\Apache Software Foundation\Apache2.2\htdocs\gkpro\act_checkin.cfm:
line 55*

53 : 
54 : *55 :  *
56 : 
57 :   INSERT INTO tbl_onshift (girlid, girlwname)

Any ideas?


Thanks




On 10/30/07, Hareni Venkatramanan <[EMAIL PROTECTED]> wrote:
>
> Hi Toby,
>
> There is an extra #) in the insert query inside your cfloop tag. If you
> remove it, it should work fine.
>
> Thanks,
> Hareni
> Adobe CF team
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: 30 October 2007 18:48
> To: CF-Talk
> Subject: fixing a piece of code
>
> Hi there
>
> I have a 2 programs one which displays dual select boxes on the screen.
> A user click on  a persons name in the left-hand selection box and move
> the name to the right-hand box and vice versa.
>
> A button is at the bottom of the screen and when the user presses the
> button the names in the right hand sidebox will then be used to update a
> table in the database.
>
> The trouble is that the code isnt working and  cant see why:
>
> I keep getting an error:
>
> Context validation error for the cfloop tag.
> The start tag must have a matching end tag. An explicit end tag can be
> provided by adding . If the body of the tag is empty, you can
> use the shortcut .
>
> Here is the code that I have:
>
>  username="#request.db_login#" password="#request.db_pwd#">
>DELETE
>FROM tbl_onshift
> 
>
> 
>  username="#request.db_login#" password="#request.db_pwd#">
>  INSERT INTO tbl_onshift (girlid, girlwname)
>  VALUES ('#q#', #form.girlwname#)#)
> 
> 
>
> Any thoughts would be greatly appreciated - I have been stuck on this
> for a couple of hours.
>
> Regards
>
>
>
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292326
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Can this be done

[Peter Tanswell]

Yeah


I had just been browsing a book on AJAX, but havent used it before so a
liitle bit lost.

Any suggestions or anywhere where I can get enough info to let me do this?

Thanks in advance.





On 10/30/07, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> Sounds like a good place for a little ajax magic. When you check a box,
> it'd
> be cool to update the status without leaving or refreshing the page.
> You could also use some ajax to have the remaining time update in real
> time
> as well.
>
> ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
>
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292322
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: mysql query

[Peter Tanswell]

ah yes there were a few extra lines

AND (visaudactweight.AuditorID = AuditorNames.AuditorID))
  AND (visaudactweight.CompanyID = CompanyNames.CompanyID))
  AND (visaudactweight.GKprRecID = GateKeeperRecs.GKprRecID))
  AND (GateKeeperRecs.GKeeperID = GKeeperNames.GKeeperID))

but its the AS MATTOTAL which is causing the problem


On 10/21/07, Brian Kotek <[EMAIL PROTECTED]> wrote:
>
> Well unless there is more to the where clause that you didn't paste, all
> those extra parentheses are going to cause an error, in addition to the
> fact
> that you're not joining any of the other tables.
>
> On 10/20/07, Toby King <[EMAIL PROTECTED]> wrote:
> >
> > Hi there
> >
> > I have a query that I have created - it works against a MS-Access
> database
> > but does not work with MySQL. I have searched through the MySQL notes
> that I
> > have but cant find out why - I think its because of the AS MatTotal
> section
> > of the query.
> >
> > Thanks in advance for feedback
> >
> >
> > SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime
> ,
> > CompanyNames.CompanyName, GateKeeperRecs.RegoNo,
> GKeeperNames.GKeeperName,
> > AuditorNames.AuditorName , GateKeeperRecs.NetWeight,
> > (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry +
> > visaudactweight.Cardboard_CompactedWet +
> > visaudactweight.Cardboard_LooseDry + visaudactweight.Cardboard_LooseWet+
> > visaudactweight.Cardboard_Waxed + visaudactweight.Clay +
> > visaudactweight.CleanFill + visaudactweight.Concrete +
> > visaudactweight.Food_Kitchen +
> > visaudactweight.Garbags + visaudactweight.Glass +
> > visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn+
> > visaudactweight.Leather_TextilesMatt +
> visaudactweight.Leather_TextilesCar+
> > visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous +
> > visaudactweight.Paper +
> > visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard +
> > visaudactweight.PlasterBoard + visaudactweight.Polystyrene +
> > visaudactweight.Rocks_Bricks + visaudactweight.Rubble +
> > visaudactweight.Soil + visaudactweight.Tyres_Rubber +
> > visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber +
> > visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing +
> > visaudactweight.Wood_Furniture + visaudactweight.Other_CD +
> > visaudactweight.Other_CI + visaudactweight.Hazardous)
> > AS MatTotal, ((MatTotal - 
> > GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100
> as PercentDiff
> > FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs,
> > GKeeperNames
> > WHERE (visaudactweight.SiteID = Sites.SiteID)
> >
> >
>
> 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291680
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Help with MySQL Query

[Peter Tanswell]

Hi there

I have a query that I have created - it works against a MS-Access database
but does not work with MySQL. I have searched through the MySQL notes that I
have but cant find out why - I think its because of the AS MatTotal section
of the query.

Thanks in advance for feedback


SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime,
CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName,
AuditorNames.AuditorName, GateKeeperRecs.NetWeight,
(visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry +
visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry+
visaudactweight.Cardboard_LooseWet + visaudactweight.Cardboard_Waxed +
visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete+
visaudactweight.Food_Kitchen +
visaudactweight.Garbags + visaudactweight.Glass +
visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn +
visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar +
visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous +
visaudactweight.Paper +
visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard +
visaudactweight.PlasterBoard + visaudactweight.Polystyrene +
visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil+
visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden +
visaudactweight.Wood_Timber +
visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing +
visaudactweight.Wood_Furniture + visaudactweight.Other_CD +
visaudactweight.Other_CI + visaudactweight.Hazardous)
AS MatTotal, ((MatTotal -
GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100
as PercentDiff
FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs,
GKeeperNames
WHERE (visaudactweight.SiteID = Sites.SiteID)


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291660
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Row total columns

[Peter Tanswell]

Hi there


I have a program which produces output as follows:



  *Projects*
   Project 1 - revenue:
   Project 2 - revenue:


 Project 3 - revenue:

 Total Revenues:   Jul
2006 *month*  *$*1,500.00 *BBB*
  *$*0.00 *BBB*
   *$*0.00 *BBB*
   *$1,500.00*

























Its calculating the column totals correctly,  (only shown July but it shows
Jul-June) - with a Total column at the end - but I am struggling a little on
the best approach so as to calculate the row totals.



I am thinking of creating an array, and then each time I get a new column I
add the value in question to the array (I know that there will always be 12
columns).  I'm stumped though on determining the number of rows – there
could be 3 or there could be 23.



How would you recommend handling this.  Is it as simple as just setting up
an array or would you suggest a better approach?



Thanks in advance.


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291304
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: using array data to create a cfchart

[Peter Tanswell]

Thanks - worked like a charm

T


On 10/15/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> Just loop over the array
>
> 
>
> 
>
>
> Regards
> Dale Fraser
>
> http://learncf.com
>
> -Original Message-
> From: Peter Tanswell [mailto:[EMAIL PROTECTED]
> Sent: Monday, 15 October 2007 9:49 AM
> To: CF-Talk
> Subject: using array data to create a cfchart
>
> Hi there
>
> I have created two arrays which contain the data that I want to report on
> using cfchart.
>
> Basically I have a person name array and a person sales array.  I am
> trying
> to work out how I can use the data in the arrays to produce the cfchart.
>
> Currently I have hard coded the information into the cfchart below, but
> this
> is limiting as this report will run for various retail stores and I dont
> know the sles people from each store.
>
>chartwidth="950"
>chartheight="500"
>xaxistitle="Sales Staff"
>yaxistitle="Revenue"
>show3d="Yes">
>  type="pie"
> serieslabel="Sales Staff"
> seriescolor="##ffcc00">
> 
> 
> 
> 
> 
> 
> 
> 
>
>
>
>
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291066
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

using array data to create a cfchart

[Peter Tanswell]

Hi there

I have created two arrays which contain the data that I want to report on
using cfchart.

Basically I have a person name array and a person sales array.  I am trying
to work out how I can use the data in the arrays to produce the cfchart.

Currently I have hard coded the information into the cfchart below, but this
is limiting as this report will run for various retail stores and I dont
know the sles people from each store.


 
  
  
  
  
  
  
 



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ColdFusion & Kavachart

[Peter Tanswell]

Hi there

I'm just wondering if anyone has used KavaChart with ColdFusion before.  I'm
trying to finish off a chart but am struggling a little as I havent used
this charting tool before.

I look forward to any feedback.

Thanks

Toby


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289200
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: urgent help required - using a users selection to select specific data

[Peter Tanswell]

Nope not getting any error - its actually working the first part - can I
email you off list and show you




On 9/23/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Ok are you getting an error when you first come to the page?
>
>
>
> -Original Message-
> From: Peter Tanswell [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:03 AM
> To: CF-Talk
> Subject: Re: urgent help required - using a users selection to select
> specific data
>
> Hi yes - the form is being resubmitted to itself.
>
>
>
>
> On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> >
> > One issue, is your probably getting an error from:
> > FORM.TIMEDATE_PERIOD does not exist.
> > Unless the form is being submitted from a previous form.
> >
> > Are you submitting the form right back to itself?
> >
> > If not, then why do you need the  statement in the OPTIONs
> >
> > If so, add a form parameter at the top of the page:
> > 
> >
> >
> >
> > -Original Message-
> > From: Toby King [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, September 22, 2007 10:27 AM
> > To: CF-Talk
> > Subject: urgent help required - using a users selection to select
> > specific data
> >
> > Hi there
> >
> > I'm really stuck on this issue - have been trying to work it out for
> > several hours so would really appreciate some input as to what I need
> > to do.
> >
> > I have displayed on screen an option where a user can select a month
> > of a year to select specific data.
> >
> >
> > 
> >   > class="printhide">  Graph Comparison Month
> > 
> > 
> >  > Check_Periods.timedate_id>selected>#dateformat(dateend, "
> > ")#> style="font-weight:bold;color:dodgerblue;background-color:white;border
> > :n
> > one;">
> > 
> > 
> >  
> > 
> > 
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289196
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: urgent help required - using a users selection to select specific data

[Peter Tanswell]

I guess a bit of both - I know what I need to but have been struggling with
what to do to get it working.

Perhaps what I have asked is a bit over the top - if it is I apologise - if
necessary if its more than a 5-10 min fix solution to agree a small
consulting fee to get pointer to the right answer.


On 9/23/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Are you having a problem or just don't know how to do the task?
>
> -Original Message-
> From: Peter Tanswell [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 9:55 AM
> To: CF-Talk
> Subject: Re: urgent help required - using a users selection to select
> specific data
>
> >
> > Hi there
> >
> > I'm really stuck on this issue - have been trying to work it out for
> > several hours so would really appreciate some input as to what I need
> to do.
> >
> > I have displayed on screen an option where a user can select a month
> > of a year to select specific data.
> >
> >
> > 
> > 
> >
> >   
> >  Graph Comparison Month
> >  onChange="document.form1.submit()">
> > 
> > > form.timedate_period eq
> Check_Periods.timedate_id>selected>#dateformat(dateend, "
> ")#
> > 
> > 
> >   >
> style="font-weight:bold;color:dodgerblue;background-color:white;border:n
> one;">
> >  
> >  
> >   
> > 
> > 
>
>
> 
>
>
>
> SET ARITHIGNORE ON
> SELECT  (peopleSummaryBilledDays*#billable_hoursperday#) +
> peopleSummaryBilledHours AS peopleSummaryBilledHours,
>people_FirstName,
>people_LastName
> FROM  dbo.peopleSummary AS ps
> INNER JOIN dbo.People AS p ON p.people_Id =
> ps.peopleSummary_peopleId
> WHERE  peopleSummaryPeriod = #thisperiod#
> AND   people_id = #people_id#
> ORDER BY  people_LastName
>
>
>
>
>
>
>
>   
>
> #getPeopleData.peopleSummaryBilledHours#
>  getPeopleData.peopleSummaryBilledHours>
> 
> 
> 
>   getPeopleData.peopleSummaryBilledHours>
> 
>
> - 
>
>   
>  
>
> 
>
>   
>
>
> Basically what I have - I have a table being displayed on the screen a
> bit like the following:
>
> Year  2006
> Select Month   Aug
>
> PeopleAlbertBrownCraig
> Totals
> Hrs July 20  30
> 4090
> Hrs Aug 10  20 20
> 50
>
> Total  30 50
> 60   140
> Avg15 25
> 30   70
>
> What I would like to do is let the user select a month - and when they
> do this highlight on the table the month which they have selected.
>
> Its probably simply but I am really struggling with this.
>
> I need to try and complete this in the next 6-10 hours so any feedback
> and info would be really appreciated.
>
> Thanks in advance.
>
> Toby
>
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289194
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: urgent help required - using a users selection to select specific data

[Peter Tanswell]

Hi yes - the form is being resubmitted to itself.




On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD
> does not exist.
> Unless the form is being submitted from a previous form.
>
> Are you submitting the form right back to itself?
>
> If not, then why do you need the  statement in the OPTIONs
>
> If so, add a form parameter at the top of the page:
> 
>
>
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:27 AM
> To: CF-Talk
> Subject: urgent help required - using a users selection to select
> specific data
>
> Hi there
>
> I'm really stuck on this issue - have been trying to work it out for
> several hours so would really appreciate some input as to what I need to
> do.
>
> I have displayed on screen an option where a user can select a month of
> a year to select specific data.
>
>
> 
>   class="printhide">  Graph Comparison Month
> 
> 
>  Check_Periods.timedate_id>selected>#dateformat(dateend, "
> ")#style="font-weight:bold;color:dodgerblue;background-color:white;border:n
> one;">
> 
> 
>  
> 
> 
>
>
>
>
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289192
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: urgent help required - using a users selection to select specific data

[Peter Tanswell]

>
> Hi there
>
> I'm really stuck on this issue - have been trying to work it out for
> several hours so would really appreciate some input as to what I need to do.
>
> I have displayed on screen an option where a user can select a month of a
> year to select specific data.
>
>
> 
> 
>
>   
>  Graph Comparison Month
> 
> 
> Check_Periods.timedate_id>selected>#dateformat(dateend, " ")#
> 
> 
>   style="font-weight:bold;color:dodgerblue;background-color:white;border:none;">
>  
>  
>   
> 
> 






 SET ARITHIGNORE ON
 SELECT  (peopleSummaryBilledDays*#billable_hoursperday#) +
peopleSummaryBilledHours AS peopleSummaryBilledHours,
people_FirstName,
people_LastName
 FROM  dbo.peopleSummary AS ps
 INNER JOIN dbo.People AS p ON p.people_Id = ps.peopleSummary_peopleId
 WHERE  peopleSummaryPeriod = #thisperiod#
 AND   people_id = #people_id#
 ORDER BY  people_LastName







   

 #getPeopleData.peopleSummaryBilledHours#
 
 
 
 
  
 

 - 

   
  

 

   


Basically what I have - I have a table being displayed on the screen a bit
like the following:

Year  2006
Select Month   Aug

PeopleAlbertBrownCraig   Totals
Hrs July 20  30
4090
Hrs Aug 10  20 20
50

Total  30 50
60   140
Avg15 25
30   70

What I would like to do is let the user select a month - and when they do
this highlight on the table the month which they have selected.

Its probably simply but I am really struggling with this.

I need to try and complete this in the next 6-10 hours so any feedback and
info would be really appreciated.

Thanks in advance.

Toby


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289188
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: displaying times on the screen

[Peter Tanswell]

Hi there

I tried that and still not with any degree of luck.  This is proving a
little frustrating - I'm close to getting it done but still miles away so it
seems.

Toby


On 9/14/07, Robert Harrison <[EMAIL PROTECTED]> wrote:
>
> Use the CreateTimeSpan function, then format your result for output using
> TimeFormat.
>
> Robert B. Harrison
> Director of Interactive services
> Austin & Williams
> 125 Kennedy Drive, Suite 100 Hauppauge NY 11788
> T : 631.231.6600 Ext. 119
> F : 631.434.7022
> www.austin-williams.com
>
> Great advertising can't be either/or... It must be &.
>
>
>
>
> 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288453
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

displaying times on the screen

[Peter Tanswell]

 have a page in my application where I want to refresh the screen every 60 
seconds without the user having to click enter - so I have used the  and it seems to work well.

Basically I want to display a clock of sessions with Gym instructors/Personal 
Trainers.

In my db i have the field finishtime which is stored. I have 2 records in the 
file one has the finish time as 17:00:00 and the other has the finish time as 
18:00:00

The system time is displayed on the screen as:

05:54:49 PM 

My results on the screen are:

Finish Time Time Remaining
04:20:00 PM 10:25:11
06:00:00 PM 12:05:11

These time are somewhat out and I cant figure out why. I think I have taken the 
correct aproach but if anyone can advise on a better approach that would be 
much appreciated. 

I have checked the program again with the time now 
06:00:30 PM and the time remaining now shows as 58:29 when it should simply say 
1:30 overtime 



My code is:





#timeformat (timeremaining, "hh:mm:ss")#



Thanks in advance for any thoughts/feedback



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288341
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Improving an application

[Peter Tanswell]

Hi there

I have completed the development of an application for a local gym.  Basically 
it is an application to manage the hiring of exercise bikes.  Each of the bikes 
- up to 50 of them can be hired out for periods of time - usually 1 hour at a 
time.

Users of the system are able to enter details of the person hiring the bikes 
etc.  Also they will select the bike and also the time that the hire starts and 
then the finish time is automatically calculated.

What the users would like to make the system more user friendly is for the 
system to somehow notify them that the hire is coming to an end.  At this 
stage, I display on the main screen the current hires in a table.  It shows 
details of the bike, the hirer, the time the hire started.  

I'm really looking for ideas on how to implement this extra functionality.  

My thoughts - can I set up the page to perform an automatic refresh say every 
minute.  I just need some way to display clearly that a hire is almost complete.

Thanks in advance.

Toby 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288029
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

charting solution for using with CF

[Peter Tanswell]

Hi there

I'm trying to find a good charting tool to use with CF and also with a MSSQL 
database to produce graphs and also dashboard style reports/graphs.

Wondering what tools software people have used for doing this.

Look forward to seeing replies.

Many thanks

Toby 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287784
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Text Field Auto-Fill

[Peter Tanswell]

Hi there

I have a site which I put together in a few hours.

I have one piece of code which works on another site but for some reason isnt 
working on this site and I cant see why?


  
  


  




Basically I'm expecting that is someone clicks on the field they will clear the 
field so they can enter their email address - but for some reason the field is 
not being cleared.

Many thanks in advance 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checking on an approach

[Peter Tanswell]

Hi all

I have a program that I have been asked to modify and enhance.

This is easily done (well relatively easy) but I would like to get some
feedback re the way the program is currently structured.

The application uses a MSSQL database to store information.  Currently
Stored Procedures are not used at all in the entire application.  The
application runs on a CF7 standard platform and IIS.  There are no CFCs used
in the application.  All queries are used "inline"

Now for the interesting part.

Lets say the program is supposed to display a list of salesmen and their
sales for Jan, Feb & Mar

So in the program there is a header line to list what each column of the
display is.

Then the detail lines there are


query get salesman
query get salesman and jan figures
query get salesman and feb figures
query get salesman and mar figures


then a total line

So basically everytime a line is produced for a salesman then the queries
are run.  This to me seems would be one reason why the program takes a long
period of time to run.

Queries are being run multiple times which seems very inefficient.

Just wondering what others think.

Regards


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287480
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: coldfusion and Apache

[Peter Tanswell]

thanks this fixed the issue.

P


On 8/18/07, Kym Kovan <[EMAIL PROTECTED]> wrote:
>
> Peter Tanswell wrote:
> > Hi there
> >
> > I have just installed CF8 and Apache and everything seems to be working.
> >
> > I go to view a website on the server e.g.
> >
> > ...
> > The only way I can view the website is by typing:
> >
> > http://127.0.0.1/beecroftflowerplace/index.cfm
> >
> > When I enter this the website displays as intended.
> >
> > I'm guessing I have to add the index.cfm file somewhere so that it knows
> that it should be a file to open up in the browser.
> >
>
> yes, you need to add index.cfm to the directoryindex directive:
>
> DirectoryIndex index.cfm index.html
>
> etc
>
>
>
> Kym K
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286551
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

coldfusion and Apache

[Peter Tanswell]

Hi there 

I have just installed CF8 and Apache and everything seems to be working. 

I go to view a website on the server e.g. 

http://127.0.0.1/beecroftflowerplace   

and I get displayed 

Index of /beecroftflowerplace 
Parent Directory 
Application.cfm 
CWDetails.cfm 
CWErrorException.cfm 
CWErrorRequest.cfm 
CWOrderForm.cfm 
CWShowCart.cfm 

etc 


The only way I can view the website is by typing: 

http://127.0.0.1/beecroftflowerplace/index.cfm 

When I enter this the website displays as intended. 

I'm guessing I have to add the index.cfm file somewhere so that it knows that 
it should be a file to open up in the browser.

THanks in advance for responses 


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286549
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfoutput and groups

[Peter Tanswell]

Hi there

I have a query where I am getting information from 2 tables.

Basically a category table i.e. categories are face, body & breasts

Users have entered details of cosmetic enhancementprocedures according to 
whether the procedure is for face, body or breasts, e.g. face has face lift, 
rhinoplasty, browlift, Body has liposuction, tummy tuck etc

On the site I want to display the information in the respective groups hence 
body, face and breasts.

My query is as follows:


SELECT  cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename, 
ce.cedetails, ce.ceresults
FROM  tbl_cosmeticenhancement ce, tbl_cecategories cecat
WHERE  ce.cecategoryid = cecat.cecatid
Order by cecat.cecategory


Then I was going to have 



#qGetCEProcedures.cecategory#
#qGetCEProcedures.cename#


What I am finding is that I am only getting one result displayed for each 
category instead of 3 or 4. 

Thanks in advance for feedback. 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285548
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

createodbcdate

[Peter Tanswell]

Hi there

I am trying to finish an application.

I want to create two dates - a start date and and an ending date which is 5 
days after the start date.

I have #CreateODBCDate(eventdate)#, for creating the start date and I tried to 
use #CreateODBCDate(eventdate)+5# for the end date - but it did not like this - 
just wondering if anyone has any ideas.

Thanks in advance.


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283749
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF7 on Apache

[Peter Tanswell]

Hi there


I have just installed CF7 on an Apache web server.

When I got to open the administrator instead of getting the administrator 
screen I am getting an option to open or save the program.

I am presuming that I have forgotten to set somthing up somewhere - just 
wondering if anyone knows what I might have forgotten to do.

Thanks in advance.

P

~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282244
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cf7 and apache

[Peter Tanswell]

Have just installed CF7 to run with Apache but when I got to browse the 
Administrator I am getting an option to open or save index.cfm

I am not browsing to get the administrator page.

Any ideas?

Regards & thanks

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282247
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF7.02 IIS7 & Vista

[Peter Tanswell]

Hi there

I started a thread on this yesterday but cant locate the thread - so here is 
another message.



I have CF7.02 working on Vista - well its partly working on Vista with IIS 7.

The problem I found when I try to browse the server - I get an error IO server 
communication error.  I cant browse to find an access database, and I cant 
browse to set up a mapping.

This is really bugging me as I havent been able to find away to get around this 
error.

If I then open Dreamweaver, in the application panel I cant view database via 
the RDS server.

~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Error

[Peter Tanswell]

No from a different .exe.





>Sounds odd, but have all these installs been from the same .exe?  If yes,
>download a fresh installer and try again.
>
>
>
>
>
>
>"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
>Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
>Registered in England, Number 678540.  It contains information which is
>confidential and may also be privileged.  It is for the exclusive use of the
>intended recipient(s).  If you are not the intended recipient(s) please note
>that any form of distribution, copying or use of this communication or the
>information in it is strictly prohibited and may be unlawful.  If you have
>received this communication in error please return it to the sender or call
>our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
>communication are not necessarily those expressed by Reed Exhibitions." 
>Visit our website at http://www.reedexpo.com
>
>-Original Message-
>From: Peter Tanswell
>To: CF-Talk
>Sent: Mon Jun 25 08:04:50 2007
>Subject: Re: Server Error
>
>Here is a further update
>
>Decided to uninstall and reinstall CFMX7.  I'm still having the same isue
>occur.
>
>I still get the message occuring.
>
>I tried opening Dreamweaver and when I do I am getting a message that
>
>I opened a .cfm program, then clicked on databases in the Application Panel.
>Then clicked on option 4 - Specify the RDS Login information for ColdFusion
>server.  The result instead of getting a list of databases I am getting a
>popup error message:
>
>The server name or address could not be resolved.
>
>Possible reasons:
>
>1. The URL specified for this site's testing server may be incorrect:
>http://localhost/mysite/
>
>2. The testing server may be incorrectly configured (for example, ColdFusion
>may not be running)
>
>I have contacted Adobe but with no luck.
>
>This is becoming a critical issue that I need to get resolved.
>
>Regards
>
>
>
>
>file?

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282008
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Error

[Peter Tanswell]

Here is a further update

Decided to uninstall and reinstall CFMX7.  I'm still having the same isue occur.

I still get the message occuring.

I tried opening Dreamweaver and when I do I am getting a message that

I opened a .cfm program, then clicked on databases in the Application Panel.  
Then clicked on option 4 - Specify the RDS Login information for ColdFusion 
server.  The result instead of getting a list of databases I am getting a popup 
error message:

The server name or address could not be resolved.

Possible reasons:

1. The URL specified for this site's testing server may be incorrect:
http://localhost/mysite/

2. The testing server may be incorrectly configured (for example, ColdFusion 
may not be running)

I have contacted Adobe but with no luck.

This is becoming a critical issue that I need to get resolved.

Regards




>> Hi - well still no luck rebooted after chaning things and 
>> still get the error message - nothng seems to have changed.
>> 
>> Thinking about uninstalling and reinstalling CF as well.
>
>That is unlikely to make any difference. Are you only getting this error
>using the Java browser applet? You don't need that to set up your Access
>datasource. Are you using a drive mapping to get to this remote Access file?
>CF doesn't know about drive mappings, unless you created persistent drive
>mappings using the same account in which CF is running.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Software provides the highest caliber vendor-authorized
>instruction at our training centers in Washington DC, Atlanta,
>Chicago, Baltimore, Northern Virginia, or on-site at your location.
>Visit http://training.figleaf.com/ for more information!
>
>This email has been processed by SmoothZap - www.smoothwall.net

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282005
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Error

[Peter Tanswell]

ok got around this problem

Not sure yet if I have got around the original problem.

Will advise soon.




On 6/25/07, Peter Tanswell <[EMAIL PROTECTED]> wrote:
>
> I decided to uninstall and reinstall CFMX7
>
> Again I followed all the steps and now I'm getting
>
> *HTTP Error 500.0 - Internal Server Error* when trying to open up the
> Administrator page.
>
> Cant see why this is happening.  I have been through the steps a coule of
> times checking and rechecking.
>
> Any thoughts would be really appreciated.
>
> Regards
>
>
>
>
> On 6/24/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
> >
> > Peter Tanswell wrote:
> > >
> > > I dont think its an access problem - it was working with CF7.02previously
> > > without any problems.  I think it has to be a CF7-Vista issue and
> > quite
> > > likely a CF error or permission setting.  I get the same error message
> > when
> > > I try to browse for files when trying to set up mappings.
> >
> > Just type the path instead of browsing for it.
> >
> > Jochem
> >
> > 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282000
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Error

[Peter Tanswell]

I decided to uninstall and reinstall CFMX7

Again I followed all the steps and now I'm getting

*HTTP Error 500.0 - Internal Server Error* when trying to open up the
Administrator page.

Cant see why this is happening.  I have been through the steps a coule of
times checking and rechecking.

Any thoughts would be really appreciated.

Regards




On 6/24/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>
> Peter Tanswell wrote:
> >
> > I dont think its an access problem - it was working with CF7.02previously
> > without any problems.  I think it has to be a CF7-Vista issue and quite
> > likely a CF error or permission setting.  I get the same error message
> when
> > I try to browse for files when trying to set up mappings.
>
> Just type the path instead of browsing for it.
>
> Jochem
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281998
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Server Error

[Peter Tanswell]

Hi - well still no luck rebooted after chaning things and still get the
error message - nothng seems to have changed.

Thinking about uninstalling and reinstalling CF as well.  Even thinking as
this is only a development machine maybe trying CF8.

Any ideas on whether this would be a reasonable approach?

Regards




On 6/24/07, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > Thanks for that - made that change but still getting the
> > error - might reboot and see if it is still occuring as well.
>
> As Dean mentioned, you might not be able to use the Java browser applet to
> choose the datasource, either.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> This email has been processed by SmoothZap - www.smoothwall.net
>
>
> 

~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281974
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Server Error

[Peter Tanswell]

Thanks for that - made that change but still getting the error - might
reboot and see if it is still occuring as well.




On 6/24/07, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > How do I work this last one out?
>
> Just like the documentation tells you to:
> http://livedocs.adobe.com/coldfusion/7/htmldocs/0055.htm
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> This email has been processed by SmoothZap - www.smoothwall.net
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281972
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Error

[Peter Tanswell]

Hi there

Yes - the access file I was trying to browse to was in the folder:

c:/inetpub/wwwroot/contactmanager/database/contacts.mdb

I can browse everything on the computer using search on vista

What account is the ColdFusion server running as? If it's running as the
default SYSTEM, it won't have rights to network shares.  ???

How do I work this last one out?

Regards



On 6/24/07, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > I have recently installed ColdFusion 7.02 on Windows Vista.
> > It all appeared to be working fine, until I had to go an set
> > up datasource for a microsoft access database.  Then I tried
> > setting up a mapping.  When I tried both of these I get the
> > following error.
> >
> > IO error on server communication.  Basically it doesnt seem
> > to be able to browse to folders on the server.
>
> Presumably, the Access file is on this other server?
>
> What happens when you try to browse the server yourself, from the Vista
> machine's console?
>
> What account is the ColdFusion server running as? If it's running as the
> default SYSTEM, it won't have rights to network shares.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> This email has been processed by SmoothZap - www.smoothwall.net
>
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281968
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Error

[Peter Tanswell]

Hi there

I dont think its an access problem - it was working with CF7.02 previously
without any problems.  I think it has to be a CF7-Vista issue and quite
likely a CF error or permission setting.  I get the same error message when
I try to browse for files when trying to set up mappings.

Regards

Pete


On 6/24/07, [Sunshine Tech Solutions] Ravi Gehlot <
[EMAIL PROTECTED]> wrote:
>
> Hey Pete,
>
> Check to see if your version of access works fine with ColdFusion 7.0.2.
> Sometimes, you have to download a special driver and install it on your
> ColdFusion directory so that your datasources may work ok.
>
> Just a thought,
> Ravi.
>
> Peter Tanswell wrote:
> > Hi there
> >
> > I have recently installed ColdFusion 7.02 on Windows Vista.  It all
> appeared to be working fine, until I had to go an set up datasource for a
> microsoft access database.  Then I tried setting up a mapping.  When I tried
> both of these I get the following error.
> >
> > IO error on server communication.  Basically it doesnt seem to be able
> to browse to folders on the server.
> >
> > I have googled this and found information on the Adobe website saying I
> had to make a change to the web.xml file in the web-inf folder.
> >
> > I checked this file and it looked fine.
> >
> > I'm stumped on this one.
> >
> > Just wondering if anyone else might have experienced this problem and if
> so how they resolved it.
> >
> > I can set up datasource if its a MySQL database.
> >
> > Thanks in advance for feedback.
> >
> > Pete
> >
> >
> >
>
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281965
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Server Error

[Peter Tanswell]

Hi there

I have recently installed ColdFusion 7.02 on Windows Vista.  It all appeared to 
be working fine, until I had to go an set up datasource for a microsoft access 
database.  Then I tried setting up a mapping.  When I tried both of these I get 
the following error.

IO error on server communication.  Basically it doesnt seem to be able to 
browse to folders on the server.

I have googled this and found information on the Adobe website saying I had to 
make a change to the web.xml file in the web-inf folder.

I checked this file and it looked fine.

I'm stumped on this one.

Just wondering if anyone else might have experienced this problem and if so how 
they resolved it.

I can set up datasource if its a MySQL database.

Thanks in advance for feedback.

Pete


~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281962
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

ColdFusion & Spectra - Install on Windows Server 2003

[Peter Tanswell]

Hi there

I have an interesting problem.  A firm I am doing some work for is trying to 
move Spectra v1.5.2 (I think thats the correct version) from Windows Server 
2000 to Windows Server 2003 with an Oracle database.

A problem that they are finding is that it is possible to login when attached 
to the server, but users have been unable to login via workstations.

They appear to have tried everything but have been unable to login from a 
workstation.

Wondering if anyone has any idea what might be causing this issue.

The login framework appears to be working OK, it appears to be some type of 
issue with session management or the use of cookies.

If anyone has any ideas or knowledge it would be greatfully accepted.

Regards



~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279804
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: creating xml formatted out from table in database

[Peter Tanswell]

Hi there

Thanks for that.

I'm trying to do something on the fly in the next half hour.

This is what I have so far


select *
from users
order by lname






  #fname#
  #lname#


 

Havent used cfxml before - I just need to show someone the results in approx 
1/2 hour

Thanks in advance

P

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279401
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

creating xml formatted out from table in database

[Peter Tanswell]

Hi there

Just trying to figure something out.

I have a form and an action page to write data to a table in the database.  I 
am collecting a persons first and last name and email address.  I want to be 
able to send this information to an xml formatted output so it can be used in a 
flash application.

The first part is easy, just wondering if someone could advise on the second 
part getting to XML formatted output from the table in the database.

Many thanks


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

List of Countries

[Peter Tanswell]

Hi there

Just wondering if anyone knew of a source where I can obtain a list of 
countries.  Hopefully in a format that I can import into a table in a database.

Thanks in advance.

P

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272470
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF Change Control/Change Request Systems

[Peter Tanswell]

Hi someone replied direct to me in relation to an application but I mistakenly 
deleted the email.

If you replied could you please reply again.

Many thanks

P


>Hi All
>
> 
>
>Just wondering if anyone has seen or may know of any small CF based change
>control/change request applications that may be available that may be able
>to be demod or available for purchase.
>
> 
>
>Thanks in advance.
>
> 
>
>Pete

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263133
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Handling Attachments

[Peter Tanswell]

Columns have been adjusted



-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 5 December 2006 2:44 AM
To: CF-Talk
Subject: RE: Handling Attachments

> I am getting an error saying I have the wrong number of columns specified

That's because you have the wrong number of columns specified :-)

You have 16 columns specified but only 15 values (that's without the
commented fields and values. VCID is the missing value. If its an
autoincrementing field, just take vcid out of the field list (first set of
parenthesis) else give it a value in the second set of parns.


...:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 

 


-Original Message-
From: Peter Tanswell [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 04, 2006 9:59 AM
To: CF-Talk
Subject: RE: Handling Attachments

Hi there
 
When I try to include the names of the photos into the database I am getting
an error saying I have the wrong number of columns specified.  
 
Actually I think the real problem is the fact that I don't have valid file
names to insert into the DB.
 
Any feed back would be appreciated to overcome this error/problem.
 
Thanks
 
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 5 December 2006 1:42 AM
To: CF-Talk
Subject: Re: Handling Attachments
 
On Monday 04 December 2006 14:17, Peter Tanswell wrote:
> It all seems to be working fine but when I go to submit to the database I
> am getting an error
 
Which error ?
"Too many elephants" ?
 
-- 
Tom Chiverton
Helping to heterogeneously envisioneer value-added materials
 

 
This email is sent for and on behalf of Halliwells LLP.
 
Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
St James's Court Brown Street Manchester M2 2JF.  A list of members is
available for inspection at the registered office. Any reference to a
partner in relation to Halliwells LLP means a member of Halliwells LLP.
Regulated by the Law Society.
 
CONFIDENTIALITY
 
This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 8008.
 
For more information about Halliwells LLP visit www.halliwells.com.
 
 






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262732
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Handling Attachments

[Peter Tanswell]

Hi there
 
When I try to include the names of the photos into the database I am getting
an error saying I have the wrong number of columns specified.  
 
Actually I think the real problem is the fact that I don't have valid file
names to insert into the DB.
 
Any feed back would be appreciated to overcome this error/problem.
 
Thanks
 
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 5 December 2006 1:42 AM
To: CF-Talk
Subject: Re: Handling Attachments
 
On Monday 04 December 2006 14:17, Peter Tanswell wrote:
> It all seems to be working fine but when I go to submit to the database I
> am getting an error
 
Which error ?
"Too many elephants" ?
 
-- 
Tom Chiverton
Helping to heterogeneously envisioneer value-added materials
 

 
This email is sent for and on behalf of Halliwells LLP.
 
Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
St James's Court Brown Street Manchester M2 2JF.  A list of members is
available for inspection at the registered office. Any reference to a
partner in relation to Halliwells LLP means a member of Halliwells LLP.
Regulated by the Law Society.
 
CONFIDENTIALITY
 
This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 8008.
 
For more information about Halliwells LLP visit www.halliwells.com.
 
 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262716
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Handling Attachments

[Peter Tanswell]

Hi All
 
I'm just trying to finalise something - am up to the last thing.
 
I have created a form which a user can submit so as to send an email to
someone.  Also I am saving the data entered to the database.
 
I have on the page an area where a user can upload up to 3 pictures.
 
 

Photo 1
 

Photo 2
 

Photo 3
 
 
It all seems to be working fine but when I go to submit to the database I am
getting an error - if I have the column names for the photos etc in the
query to add the record to the database then nothing is getting saved.
 
I have the following code - (note I am aware that the lines are currently
commented out.
 
The first part of the code uploads the file - and this is being done OK.
 
The code below adds the record to the DB - except at present it isnt doing
this properly if I try to add data to the field name for the photos.
 






 
 
INSERT INTO tbl_virtualconsultation(
vcid,
title,
name,
age,
gender,
email,
phone,
enquiry,
desiredresults,
timeframe,
motivation,
previouscs,
proceduredetail,
replymethod,

agree2tncs,
daterecd)
Values  ('#ThisVCID#',
'#Trim(FORM.title)#',
'#Trim(FORM.name)#',
#FORM.age#,
'#Trim(FORM.gender)#',
'#Trim(FORM.email)#',
'#Trim(FORM.phone)#',
'#Trim(FORM.enquiry)#',
'#Trim(FORM.results)#',
'#Trim(FORM.timeframe)#',
'#Trim(FORM.motivation)#',
 #Form.previouscs#,
'#Trim(FORM.proceduredetail)#',
 #Form.replymethod#,
 
 #FORM.agree2tncs#,
 #CreateODBCDate(now())#)




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262703
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

multiple selection drop down list

[Peter Tanswell]

Hi there

I am developing a website for a professional services firm (a small law firm).

One thing the firm wants is the following:

They want to display details of partners and staff and also indicate specialist 
areas that staff work in.

In summary I am using the following code:

First the query to get the various practice areas

 select * from 
tbl_practiceareas order by practicearea 



 Please Select 
selected>
#practicearea#  
  

This should allow me to make the selection(s) as appropriate and then save the 
data, along with details of the person etc.

I will probably save the selected practice areas in one field probably as a 
string.


Now the big question.

I may want to modify the details for a staff member at some stage down the 
track.

I would want to display all options which are available, but I would also want 
to show those practiceareas which the person already has selected.

I'm stumped on this one at present so any feedback tips on how to do would be 
greatfully appreciated.

Regards & thanks in advance

Peter


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261592
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

multiple selection select list

[Peter Tanswell]

Hi there

I am developing a website for a professional services firm (a small law firm).

One thing the firm wants is the following:

They want to display details of partners and staff and also indicate specialist 
areas that staff work in.

In summary I am using the following code:

First the query to get the various practice areas

 select * from 
tbl_practiceareas order by practicearea 



 Please Select 
selected>
#practicearea#  
  

This should allow me to make the selection(s) as appropriate and then save the 
data, along with details of the person etc.

I will probably save the selected practice areas in one field probably as a 
string.


Now the big question.

I may want to modify the details for a staff member at some stage down the 
track.

I would want to display all options which are available, but I would also want 
to show those practiceareas which the person already has selected.

I'm stumped on this one at present so any feedback tips on how to do would be 
greatfully appreciated.

Regards & thanks in advance

Peter


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261591
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Element LOGGEDUSERFNAME is undefined in SESSION.

[Peter Tanswell]

I keep on getting an error stating that an element is undefined in Session.

I have checked the code but cant see why this is happening.

Here is the section of code below.

Thanks in advance for an assistance given.


 
  
  
  
  SELECT * 
  FROM tbl_establishments e, tbl_estcontacts c
  WHERE ABAMbrno = '#FORM.username#' AND MbrPassword = '#FORM.password#' AND
  e.EstablishmentID = c.EstablishmentID
  

  







  
  

  
  
  
  
  
  
  
  
  
  



  
  
  
  




UPDATE tbl_establishments SET Mbr_LastLogin = #LastLogin#, 
Mbr_LoginDate = #CreateODBCDateTime(Now())# where ABAMbrno = #Form.username# 



  
  
  





  



  


  



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253469
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFMX own web server

[Peter Tanswell]

OK tried that opened up port 8500 for cfmx but still cant access the CF
Administrator.



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 29 August 2006 9:28 AM
To: CF-Talk
Subject: RE: CFMX own web server

> I have an installation that is running CFMX and its using its 
> own web server.
> 
> To access the CF Administrator on the machine I use
> 
> http://127.0.0.1:8500/cfide/administrator
> 
> I know that there is a static IP address for this server, so 
> I am wondering how do I access the server using the static IP 
> address? And how do I access an application that is located 
> in the web server.
> 
> Do I have to do anything special so as to be able to access 
> across the Internet

http://your_IP_address_or_DNS_name:8500/

If your server is behind a firewall, that firewall would need to be
configured to allow inbound traffic to TCP/8500. You can also reconfigure
the JRun web server to listen on TCP/80 or any other port:

http://www.adobe.com/support/coldfusion/adv_development/config_builtin_webse
rver/

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251326
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFMX own web server

[Peter Tanswell]

Hi there

I have an installation that is running CFMX and its using its own web
server.

To access the CF Administrator on the machine I use

http://127.0.0.1:8500/cfide/administrator

I know that there is a static IP address for this server, so I am wondering
how do I access the server using the static IP address? And how do I access
an application that is located in the web server.

Do I have to do anything special so as to be able to access across the
Internet

Regards & thanks

Pete



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251322
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF Administrator

[Peter Tanswell]

Hi there

I have just run the CF 7:02 upgrade and now when I try to browse to the CF
Administrator I keep getting an error saying:

The web site has experienced an unexpected error.  

File not found ?CFIDE/administrator/index.cfm

And then further down in the output

23:48:06.006 coldfusion runtime. TemplateNotFoundException - in : line -1

File not found: /CFIDE/administrator/index.cfm


I have checked and the file exists.  Possibly the only thing I can think of
is that I have /CFIDE/administrator on the E: drive and not in C:

Does anyone have any idea what the issue might be and how to fix it.

Regards & thanks

P



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251239
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Intranets

[Peter Tanswell]

Hi there

I've been asked r3ecently by a small firm 20-25 employees to develop an
Intranet that they can use in the organization.

Just wondering if anyone has any good example intranets that it might be
possible to have a look in relation to styles and layouts and even the type
of content that could be included.

Thanks in advance.

Regards





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250886
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Coldfusion document management system

[Peter Tanswell]

Hi there 

 

Have you seen or heard of Fusiondox - www.fusiondox.com
 

 

Regards

 

 

 

 

 

-Original Message-
From: Andrea Veggiani [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 24 August 2006 7:10 PM
To: CF-Talk
Subject: Coldfusion document management system

 

Hi,

 

we are searching for a good DMS to integrate in our legacy system.

 

We'd like to find something made in Coldfusion but really i did not find

anything on the matter; do you know some CF DMS products?

 

We liked Jlibrary but it's Java based and it lacks documentation.

 

Bye

Andrea Veggiani

 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: creating a new record in a db table

[Peter Tanswell]

I got the cfloop working and I am now able to create a record in the
database.  I want to make a small change however and I have it partly
working:

 

In the master list of names there is an id key which exists.  I am now
displaying that as part of the select list, so that that it can be moved
across as well.

I dont necessarily need to display the id, but at present I am.

Basically I just want to be sure that I can save the id when I am writing
the records to the table.

Currently I am writing the id as part of the name in the table I am
creating.

I tried including the girlid into the insert into statement but then the
program crashed because there was only one column of data. #q#  how do I get
the id and the name

Basically, how do I write 2 columns into the database.

Currently I am doing:

 



 #i#




   DELETE
  FROM testRoster


 
  
  INSERT INTO testRoster (girl_name) 
  VALUES ('#q#') 
  
 
 

 

 

 

 

-Original Message-----
From: Peter Tanswell [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 22 August 2006 4:04 AM
To: CF-Talk
Subject: creating a new record in a db table

 

OK here is a summary of what I'm trying to achieve.

 

 

 

I have displayed on the screen two select lists.  A user is then able to

select names from one select list to the other.  In fact, the select list on

the lest is a master list so all the names will appear in that list.

 

 

 

Lets say a user selects 10 names from the list on the left and moves them to

the list on the right.

 

 

 

When the user clicks submit I want to create a table that contains one

record for each name in the table on the right.

 

 

 

Currently I have the following:

 

 

 

I am displaying individual lines on the scree, but in the DB I am just

getting one record created,  The format of the record being the id field and

then the name field which looks like:

 

 

 

Abby,Bthe,Cindy,Coral-  basically comma delimted where as I want in this

case 4 separate records created in the DB.

 

 

 

Thanks in advance for any feedback

 

 

 

 

 

 

 



 



 

#i#

 



 

 

 

 

 



 

Insert into testRoster 

 

(girl_name) 

 

Values 

 

('#girls#')

 



 

 

 

 

 

 

 

 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250519
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: creating a new record in a db table

[Peter Tanswell]

>You need to loop over the comma delimited list, doing multiple inserts:
>
>
> 
>   Insert into testRoster(
>   Girl_name
>   )
>   Values(
>   '#i#'
>   )
>   
>
>   
>
>>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250515
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

creating a new record in a db table

[Peter Tanswell]

OK here is a summary of what I'm trying to achieve.

 

I have displayed on the screen two select lists.  A user is then able to
select names from one select list to the other.  In fact, the select list on
the lest is a master list so all the names will appear in that list.

 

Lets say a user selects 10 names from the list on the left and moves them to
the list on the right.

 

When the user clicks submit I want to create a table that contains one
record for each name in the table on the right.

 

Currently I have the following:

 

I am displaying individual lines on the scree, but in the DB I am just
getting one record created,  The format of the record being the id field and
then the name field which looks like:

 

Abby,Bthe,Cindy,Coral-  basically comma delimted where as I want in this
case 4 separate records created in the DB.

 

Thanks in advance for any feedback

 

 

 





#i#



 

 



Insert into testRoster 

(girl_name) 

Values 

('#girls#')



 






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250482
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4