[ cf-dev ] Posting back - Mind blank

2003-09-09 Thread Paul Swingewood
Hi everyone - back from hols and my brain no longer functions after trying to drink Tenerife dry I want to have a page that posts info back to itself How do I do this again? Initial query for years User selects the year year is passed back New query now selects schools and year etc etc

[ cf-dev ] OT SQL Group By

2004-06-19 Thread Paul Swingewood
Hi all working from home at the moment hence the hotmail email address. Can anyone help me with this please before I lose my mind (further than I have already) I have this query cfif #url.categoryID# eq 1 !--- FOOTWEAR --- cfquery name=getsubcat datasource =#application.dsn# SELECT

Re: [ cf-dev ] SOT - SQL

2004-07-06 Thread Paul Swingewood
The interesting thing is that the column on the old system does not allow nulls. This is the primary key field. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

Re: [ cf-dev ] SOT - SQL

2004-07-06 Thread Paul Swingewood
Yeah, Just found it. Indeed the import didn't set any of the key fields as they were in the source! I am no expert at SQL or have suitable qualifications to slag of Microsoft but I would have thought that an import wizard would have at least imported the properties of the columns. **Paul ducks

[ cf-dev ] Batch Processing - Admin systems

2004-07-06 Thread Paul Swingewood
I need to make an admin system that allows batch processing. The user wants to be able to add say 50 records locally and then upload them to the server. I was thinking of using a form that adds a new line each time add another record is pressed finally a submit to database button. The user

RE: [ cf-dev ] Batch Processing - Admin systems

2004-07-06 Thread Paul Swingewood
Russ, This looks just the job. Would save me a lot of time developing forms for add, delete modify etc.. Can you contact off list and we'll discuss the ins outs further ... Regards - Paul ([EMAIL PROTECTED] or [EMAIL PROTECTED] - Crappy notes server which takes forever to deliver messages)

[ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
Can anyone help me with this one please. I want to have a drop down list (quantity) When the user changes the quantity I want to update the qnty field in the table orders. How do I do this? Any ideas? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at

RE: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
is changed, submit the form to the iframe, thus updating the database without reloading the page :-) -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 16:28 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OnChange? Can anyone help me with this one please. I

RE: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 16:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OnChange? Hmm sounds simple. If only I knew how to instigate it What I have at the moment is based on the windsurfer example that comes with coldfusion server. This system uses

Re: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
=Form.quantity default=0 cfparam name=Form.ID default=0 cfquery name=updateQuantities datasource=dsn UPDATE Product SET Quantity= #Form.quantity# WHERE ID = #Form.ID# /cfquery cflocation url=someotherpage.cfm Paul Swingewood [EMAIL

Re: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
submission as it assumes you've made a change to the field. it would also work with radio buttons, but not really any other form fields. you're better off keeping the javascript to a minimum and just letting the user click a button when they're done. Paul Swingewood

Re: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
Oh yeah one other quick question ... I have a cell with shoes sizes like this 1,2,3,4,5,6,7,8,9 (a list) I want to populate a cfselect from the list ... So, CFQUERY NAME=GetItem MAXROWS=1 DATASOURCE=#application.dsn# SELECT DISTINCT tblitems.itemID, tblitems.partNum, tblitems.itemName,

Re: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
Thanks Duncan I automatically try to use CF all the time I did this in the end. select name=selectSize cfloop index = ListElement list = #GetItem.itemSize# delimiters=, cfoutput option value=#ListElement##ListElement#/option /cfoutput /cfloop /select Oh

Re: [ cf-dev ] OnChange?

2004-07-08 Thread Paul Swingewood
Thanks Duncan I automatically try to use CF all the time I did this in the end. select name=selectSize cfloop index = ListElement list = #GetItem.itemSize# delimiters=, cfoutput option value=#ListElement##ListElement#/option /cfoutput /cfloop /select Oh

[ cf-dev ] Whats wrong please?

2004-07-08 Thread Paul Swingewood
I have a field that stores the size of a shoe selected from a drop down list (itemsize) If the user changes the size they click a button to add this change to the database all works ok so far and the change is in the database. However the form is redisplayed and it would be nice to have the

Re: [ cf-dev ] Whats wrong please?

2004-07-08 Thread Paul Swingewood
Duncan I have changed the query to this CFQUERY NAME=GetCartItems datasource=#application.dsn# SELECT ItemIDPK, PartNum, ItemName, ItemCost, Quantity, tblitems.itemsize AS ItemsItemSize, tblCartItems.ItemSize AS CartItemsItemSize FROM tblItems, tblCartItems WHERE itemID = ItemIDPK

Re: [ cf-dev ] Whats wrong please?

2004-07-08 Thread Paul Swingewood
# selected#ListElement#/option cfelse option value=#ListElement##ListElement#/option /cfif /cfloop /select Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com

Re: [ cf-dev ] Whats wrong please?

2004-07-08 Thread Paul Swingewood
# = Australia (first record from the query) #ValueList(getCountries.country)# = Australia, Brazil, Canada, Denmark... (all the records from the query) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com

Re: [ cf-dev ] isdefined

2004-07-09 Thread Paul Swingewood
Stephen I changed the code as you suggested but got errors and so went back to the original code :( So if anyone can help sort his one out please I would be very grateful. (code follows) and see previous threads ... I put the cfoutput in the code to see whats being evaluated and sure enough

Re: [ cf-dev ] isdefined

2004-07-09 Thread Paul Swingewood
Woo Hoo persitance and outputting variables in code has fixed it. I now have this at the moment CFLOOP query=CartItems cfset thing = ListFindNoCase(Form.FIELDNAMES,SelectSizeReplace(ItemIDPK,-,_,ALL)) cfoutput#thing#/cfoutput cfif #thing# eq 0 CFSET NewQuantity =

[ cf-dev ] OT- SQL (Attach)

2004-07-14 Thread Paul Swingewood
In my hurry last night I copied my MDF file to disk and forgot the log file :( Is there anyway I can attach the database on my server at work with only the MDF file. I have tried 'All Tasks - Attach Database' this gives me an error about the physical filename for the logfiles being incorrect

[ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
Can anyone help me with this one please. I have the following code CFOUTPUT QUERY=GetCartItems TR TD BGCOLOR=##cc#PartNum#/TD TD BGCOLOR=##cc#ItemName#/TD td

RE: [ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
:-) just good to know..I can see that its only the original MX version 6 and no 6.1...its not related here but good to know! -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 11:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] loop the loop loopiness

Re: [ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
The query is simple enough really (I would have thought this was all ok ) I still don't see how the select list gets appended to? CFQUERY NAME=GetCartItems datasource=#application.dsn# SELECT DISTINCT ItemIDPK, PartNum, ItemName, ItemCost, Quantity,

Re: [ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
, 16 Jul 2004 11:50:48 +0100 Paul, does tblItems have a seperate row for each colour, and each size? e.g. Shoe 1, Red, size 3 Shoe 1, Red, size 4 Shoe 1, Red, size 5 Shoe 1, Black, size 3 Shoe 2, Black, size 3 Shoe 2, Black, size 3 etc etc? Paul Swingewood

RE: [ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
and items, and again between sizes and items: tblItems ID Name Description etc tblColours ID Colour tblSizes ID Size tblItem_Colours ID itemID ColourID tblItem_Sizes ID itemID SizeID Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED

Re: [ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
tables for a many-to-many relationship between colours and items, and again between sizes and items: tblItems ID Name Description etc tblColours ID Colour tblSizes ID Size tblItem_Colours ID itemID ColourID tblItem_Sizes ID itemID SizeID Paul Swingewood [EMAIL

Re: [ cf-dev ] loop the loop loopiness

2004-07-16 Thread Paul Swingewood
Doh! - Forgot to join the tables. Time for a break! Many thanks all - Regards - Paul From: Paul Swingewood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] loop the loop loopiness Date: Fri, 16 Jul 2004 12:59:34 +0100 I have created new tables

[ cf-dev ] More nuttiness

2004-07-16 Thread Paul Swingewood
Since changing the tables I have now developed a few more errors to do with the queires. I get this error Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The column prefix 'GetCartItems' does not match with a table name or alias name used in the query. Heres the

Re: [ cf-dev ] More nuttiness

2004-07-16 Thread Paul Swingewood
Thanks Duncan I noticed it after I posted it. I seem to be going round and round with this code though. I fix one thing and something else dies ...:( What I have now is sometimes it returns a colour sometimes it doesn't. Theyre all in the database! It will show the selected item only for the

[ cf-dev ] So Close!

2004-07-16 Thread Paul Swingewood
Well that was a world of fun. I fixed the first bit. At least colours ae being returned for all items now. My next problem is making the items selected in teh drop down list once they have entered the basket. It works fine for the first item but none after that :( BTW the problem with the

[ cf-dev ] Free Beer!

2004-07-19 Thread Paul Swingewood
Ok the lure of a free beer via paypal to anyone who can help me sort my previous problem out. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and

Re: [ cf-dev ] Free Beer!

2004-07-19 Thread Paul Swingewood
Heres the problem. Best viewed visually at http://217.43.93.212/store/ Select Footwear, Stilettos, Choose a shoe, put this in my basket. Change the size and the new size change is reflected in the drop down list. Perfect! Now add another stiletto to the basket change size (Dispear! - Angst and

Re: [ cf-dev ] Free Beer!

2004-07-19 Thread Paul Swingewood
are displayed in the loop? I just don't get it (enough) Regards - Paul From: Paul Swingewood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:40:26 +0100 Heres the problem. Best viewed visually at http://217.43.93.212

Re: [ cf-dev ] Free Beer!

2004-07-19 Thread Paul Swingewood
= whatever.variable cfloop query=something else #somevariable# /cfloop /cfoutput This bug might have been fixed in CFMX, not sure...? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com

Re: [ cf-dev ] Free Beer!

2004-07-19 Thread Paul Swingewood
you've done it on the itemID's, but you also need to replace references to GetCartItems.ItemSize (in the cfloop) with a local variable instead. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com

Re: [ cf-dev ] Free Beer!

2004-07-19 Thread Paul Swingewood
value=#ItemSize# selected#ItemSize#/option!--- Must be a local variable --- Many thanks Regards - Paul From: Paul Swingewood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:56:43 +0100 and just as he saves

[ cf-dev ] meaningful uuid

2004-07-22 Thread Paul Swingewood
I want to create a Unique Identifier and so I am using this code CFPARAM NAME=Cookie.CartID DEFAULT=#CreateUUID()# The problem is this creates a string which is huge like .. A5C2A55B-5004-4AF5-83CB90FECA60673E Is there a way of setting what CreateUUID creates or do I need to use ListGetAt to get

Re: [ cf-dev ] meaningful uuid

2004-07-22 Thread Paul Swingewood
, there are other ways of doing it. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] meaningful uuid

[ cf-dev ] SOT Printing....

2004-07-23 Thread Paul Swingewood
Hello all, Can anyone give me any help advice on printing webpages. I have an order confirmation that I want to print. I have been reading about using style sheets to do this. Is there anything nice in coldfusion MX that can sort this or are style sheets the way. Also will style sheet (or some

[ cf-dev ] Default value?

2004-08-02 Thread Paul Swingewood
input type=file size=35 name=smallpic value=#ItemImage# How can I set the default value for an input when the type is file? (used when the client wants to modify) Also this application is part of the backend for my shoe shop thingy. All I need to do is upload/modify two pictures that go with a

RE: [ cf-dev ] Default value?

2004-08-03 Thread Paul Swingewood
at www.cfdeveloper.co.uk. --- -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 02 August 2004 09:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Default value? input

[ cf-dev ] cftransaction

2004-08-03 Thread Paul Swingewood
I have 5 queries which populate drop down lists. I have just been reading up on cftransaction. Should I put all of these queries inside a cftransaction tag? - Does this increase speed? - How why? I don't think I need all this rollback stuff as I am only reading to populate dropdown lists.

RE: [ cf-dev ] cftransaction

2004-08-03 Thread Paul Swingewood
procedure with transactional logic with multiple result sets but again depends what youre trying to do ? Alex -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 10:22 To: [EMAIL PROTECTED] Subject: [ cf-dev ] cftransaction I have 5 queries which populate

[ cf-dev ] Ok this ones more tricky

2004-08-03 Thread Paul Swingewood
cfloop index = ListElement list = #form.modifiedsize# cfquery name=updateitemsizes datasource=#application.DSN# UPDATE tblItemSizes SET FKSizeID = '#trim(ListElement)#' WHERE FKItemID = '#trim(form.ItemID)#' /cfquery /cfloop Looking at the above code I think you'll see what I am trying to

Re: [ cf-dev ] Ok this ones more tricky

2004-08-03 Thread Paul Swingewood
more tricky Date: Tue, 3 Aug 2004 11:40:23 +0100 Are you trying to update several DBs rows based on the Primary key being in a list (modifiedsize)? Something like update table set row = 1 where id in (1,2,3) ??? On Aug 3, 2004, at 11:28 AM, Paul Swingewood wrote: cfloop index = ListElement list

Re: [ cf-dev ] Ok this ones more tricky

2004-08-03 Thread Paul Swingewood
first and then insert would be ok but doesn't this fragment the database and make it grow horribly (SQL2K)? Why? Paul Swingewood wrote: The table is like this ID FKItemID FKSizeID 1244150 1 1245150 2 1246150 3 This shows that item 150 is available

[ cf-dev ] Comments!

2004-08-03 Thread Paul Swingewood
Ok I think I have cracked this next phase for the backend of my shoes application. I would appreciate any comments on this code. Is this the right way to do it etc . Just to let you know this is the modify action page which modifies items . Regards - Paul cfparam name=PicError

[ cf-dev ] OT - This group is great!

2004-08-03 Thread Paul Swingewood
I would like to thank all of the people that have helped me so far in developing my shoes site (soon to be fudgeuk.com). I am self taught in Coldfusion (as I guess everyone is) I did the courses and then tried to apply what I learned. Its difficult when you are on your own with no one else to

Re: [ cf-dev ] Comments!

2004-08-03 Thread Paul Swingewood
the reference to an Application variable: DATASOURCE= #application.dsn# or use Request.dsn instead. Otherwise... Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc

[ cf-dev ] Dreamweaver FTP :(

2004-08-05 Thread Paul Swingewood
Does anyone out there use Dreamweaver 2004? I am using v7.01 (Latest Version?) The FTP is driving me nuts. I keep getting an error Your login information is incorrect in fact its nothing to do with this at all. Its actually the number of open instances of FTP that is causing the problem. The

[ cf-dev ] Exceptions

2004-08-05 Thread Paul Swingewood
I have begun 'snagging' my shoe site and the functionality seems to work ok. Now I need to make sure it works when it breaks - enter cfthrow cfcatch. Are there any guidelines tips tricks in using these tags? I have played with them before but never really used them in anger. If the site breaks

[ cf-dev ] calendar

2004-08-09 Thread Paul Swingewood
A while ago (cf4.5/5.0) I used some code that created a flash calendar. This was a downloadable toolkit thing. Does it still exist? I need to download it again as the file has become corrupt on the server :( Anyone know where it is or is there a better updated version for MX now? Regards - Paul

[ cf-dev ] Form Submission Problem

2004-08-12 Thread Paul Swingewood
I have the following code cfif getitems.recordcount gt 0 cfoutput query=getItems tr !--- bgcolor=##ffcdef --- td width=75 rowspan=4 cfswitch Expression=#form.ItemAction# cfcase

Re: [ cf-dev ] Form Submission Problem

2004-08-12 Thread Paul Swingewood
=hiddenValues#getItems.CurrentRow# ACTION=moditemform.cfm METHOD=POST Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] Form

[ cf-dev ] More exceptions

2004-08-12 Thread Paul Swingewood
I have a form which (amongst other things) allows the user to upload two pictures. If the user doesn't upload a pic the page after the submit crashes with 'string index out of range' The form element is input type=file size=35 name=modifiedsmallpic value=#ItemImage# Why can't I trap this like

RE: [ cf-dev ] More exceptions

2004-08-12 Thread Paul Swingewood
oops sorry silly question the heat is getting to me again cfif modifiedSmallPic eq Error with Small Pic /cfif What a nutter! - Sorry -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive:

[ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
Now this is as simple as it gets... Yeah right ... script language=JavaScript !-- function submitform() { if (document.addsubctgry.subcatpic.value == ) { alert(You must enter a picture for this subcategory.); } // -- /script . . . . . cfform name=addsubctgry action=adsbctac.cfm

Re: [ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
Still doesn't work :( From: Andy Allan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] js drives me mad Date: Thu, 12 Aug 2004 17:17:53 +0100 should be function submitForm() ... remember Javascript is case sensitive. Andy Quoting Paul Swingewood [EMAIL

Re: [ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] js drives me mad Date: Thu, 12 Aug 2004 17:24:12 +0100 what's the javascript error? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED

Re: [ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
script language=JavaScript !-- function submitForm() { if (document.addsubctgry.subcatpic.value == ) { alert(You must enter a picture for this subcategory.); } return false; } // -- /script Now this displays the error message ok but then submits the form anyway.lol I have tried return

RE: [ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
Tried all that still posts the form instead of returning to the submit page. I know have. script language=JavaScript !-- function submitForm() { if (document.addsubctgry.subcatpic.value == ) { alert(You must enter a picture for this subcategory.); return false; } } // -- /script . . . . form

RE: [ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
A search through all the 'idiots guide to js' websites and I cracked it So bloody simple it hurts! cfform name=addsubctgry action=adsbctac.cfm onsubmit=return submitForm(); enctype=multipart/form-data RETURN submitForm(); I hate js can anyone out there come up with PascalScript. Pascal no

RE: [ cf-dev ] js drives me mad

2004-08-12 Thread Paul Swingewood
Thanks Spike. Yeah I just discovered that! Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by

[ cf-dev ] unique order no

2004-08-16 Thread Paul Swingewood
Can anyone help with this please. I want to generate a unique order no. I was using CFSET NewID = CreateUUID() but the number it generates is way too long. I was thinking of creating something based on teh date and an incrementing number. Any ideas on how to do this? Regards - Paul -- These

[ cf-dev ] cfmx hosting

2004-08-17 Thread Paul Swingewood
Can anyone shed any light on hosting for me please. I have developed a site and now I want to host it. The site uses CFFILE so I guess I need to have a security sandbox. Does the hosting company do this? The site uses SQL2K for its database. Will the hosting company setup the DSN. I have an

[ cf-dev ] Driving me nuts

2004-08-17 Thread Paul Swingewood
I can't understand this ive done it a million time but now forgotten something obvious. I want to see if a variable is defined. cfif isdefined(form.modifiedbannerpic) cffile action =UPLOAD filefield =Modifiedbannerpic nameconflict = overwrite accept = image/gif

RE: [ cf-dev ] Driving me nuts

2004-08-17 Thread Paul Swingewood
QUOTES Aghhh Sorry - Regards - Paul From: Paul Swingewood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [ cf-dev ] Driving me nuts Date: Tue, 17 Aug 2004 13:56:48 +0100 I can't understand this ive done it a million time but now forgotten something obvious

RE: [ cf-dev ] Driving me nuts

2004-08-17 Thread Paul Swingewood
Thanks Duncan, Sometimes you spend so long looking at stuff which has nothing to do with the error you miss the obvious. Just spotted it as our emails passed in the ether. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive:

RE: [ cf-dev ] cfmx hosting

2004-08-17 Thread Paul Swingewood
Hi Russ, It looks like my client will be going with CFMXhosting.co.uk (If I could just get through to one of you on the phone) I have an application.cfm file like this cfset application.dsn = sqlshoes cfset name=Application.TaxRate default=0.175 cfset application.catsubcatdirectory

RE: [ cf-dev ] cfmx hosting

2004-08-17 Thread Paul Swingewood
oops didn't mean to start a hosting war. I suggested CFMX hosting to my client for all the reasons that Russ has just said. #1 that I can pick up the phone and speak to someone right now who understands what I am trying to do and who will help me achieve it. Wicked! I should point out that I am

RE: [ cf-dev ] cfmx hosting

2004-08-17 Thread Paul Swingewood
think CFMX hosting is the best solution to mine the clients needs. - Paul Swingewood, CF guru. ;-) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc

[ cf-dev ] SOT dynamic pages with search engines

2004-08-31 Thread Paul Swingewood
Can anyone give me a little advice please. My client has requested a few pages from me to be 'optimised?' for a search engine. The person doing this has requested that a descriptive text appear on certain pages of the site. For example shoes, boots, lingerie, costumes, makeup etc. The site uses

Re: [ cf-dev ] SOT dynamic pages with search engines

2004-08-31 Thread Paul Swingewood
different. http://www.google.com/webmasters/ is a good starting point too Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf

[ cf-dev ] A new problem ???

2004-09-08 Thread Paul Swingewood
Can anyone help me with the logic for this one please ... I have a table which has n number of pics in it I want to select 5 random pics (making sure that none are the same) and then display them on the screen. I have this muddled up code so far cfquery name=GetPics

RE: [ cf-dev ] A new problem ???

2004-09-08 Thread Paul Swingewood
, 8 Sep 2004 17:09:19 +0100 cfquery name=views datasource=#application.DSN# select * from tblindexpics where id IN #(pictoget)# /cfquery -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 17:03 To: [EMAIL PROTECTED] Subject

Re: [ cf-dev ] A new problem ???

2004-09-08 Thread Paul Swingewood
yup! - That seems to work ok. Thanks a lot - Can't say I really understand how all that works but it seems to do what I wanted Regards - Paul From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] A new problem ??? Date: Wed,

RE: [ cf-dev ] A new problem ???

2004-09-09 Thread Paul Swingewood
Ok this all works fine and the client lioves it. Now of course whe wants a change. There are n no of pics in the table which she now wants 'grouping'. The idea is that when the images are randomly selected the five shown are all from the same group. So lets say there are n groups. I guess it

RE: [ cf-dev ] Shopping cart

2004-09-10 Thread Paul Swingewood
I have just adapted the one that comes with CF. Took a bit of jiggery pokery and help from the group but it does what it says on the can. I have it working with PayPal and pay by Uk Cheque .. Mail me offlist and i'll send you a link to it ... (Is on my development server at the moment. Last

[ cf-dev ] OT - Host Headers etc ....

2004-09-14 Thread Paul Swingewood
Hello. Is it possible to host several websites with one IP address from say BT. I have a fixed IP address to my server but I want to be able to host several websites that I have in development? - I have read that this can be done with host headers. So can I set up my webserver to have say

RE: [ cf-dev ] OT - Host Headers etc ....

2004-09-14 Thread Paul Swingewood
Ok just so I get this in my head. If I wanted to host www.paul.co.uk, www.adam.co.uk, and www.leanne.co.uk I register the domains with whoever and tell them to point to my one IP Address (12.123.123.123) That my ISP gives me. I then set up host headers on my server for each of the websites. Is

RE: [ cf-dev ] OT - Host Headers etc ....

2004-09-14 Thread Paul Swingewood
LOL- Which means ..? I take it thats the IP address the my ISP give me (BT) Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and

RE: [ cf-dev ] OT - Host Headers etc ....

2004-09-14 Thread Paul Swingewood
Yeah ok that makes sense. I can see that at the moment via my router. It tells me the webfacing IP address and all the internal addresses. OK then that should all be ok. I have just aquired a quad PIII proliant 5500 rack mount (being thrown out from work). I want to use it to host a small

[ cf-dev ] Slect Multiple

2004-09-19 Thread Paul Swingewood
I have a modify form. I want to show the multiple values of a select that were cosen when the user entered the data. I have this !--- This query gets those sizes that were selected --- cfquery name=GetItemSizes datasource=#application.dsn# SELECT FKSizeID, FKItemID

Re: [ cf-dev ] Slect Multiple

2004-09-20 Thread Paul Swingewood
Thanks for that guys. It makes sense and seems to work all ok... Regards - Paul From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Slect Multiple Date: Mon, 20 Sep 2004 07:39:41 +0100 Russ Michaels (Snake) wrote: Put the

[ cf-dev ] The basics of Verity

2004-09-23 Thread Paul Swingewood
Hi all, I have never used Verity and woiuld like to play around with it a little. Can anyone recommend an idiots gude to verity with CFMX. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive:

RE: [ cf-dev ] The basics of Verity

2004-09-23 Thread Paul Swingewood
: Thu, 23 Sep 2004 10:52:05 +0100 The Working with Verity book which ships with CF? -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 10:51 To: [EMAIL PROTECTED] Subject: [ cf-dev ] The basics of Verity Hi all, I have never used Verity and woiuld like

[ cf-dev ] OT- Style Sheets

2004-09-28 Thread Paul Swingewood
I have a style sheet which defines the link colour. I want to switch it off for a certainlink only a href=abcFollow this link/a What do I need to put in the line above to do this ...STYLE?? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at

Re: [ cf-dev ] OT- Style Sheets

2004-09-28 Thread Paul Swingewood
: Tue, 28 Sep 2004 11:27:36 +0100 Don't you want a class then that is different from the default i.e.: a href=abc class=classNameFollow this link/a Then in your stylesheet something like: a.className{ yourStyles: xyz; } ...and make sure it comes after your default style. d Paul Swingewood wrote: I

Re: [ cf-dev ] OT- Style Sheets

2004-09-28 Thread Paul Swingewood
I should have posted some of the code I guess a:link{ color: #006699; text-decoration: none; } a:visited{ color: #006699; text-decoration: none; } a:hover{ color: #006699; text-decoration: underline; } #showCart{ margin: 10px 20px

[ cf-dev ] OT - Search Engine Optimisation

2004-09-29 Thread Paul Swingewood
I know I have asked a similar thing to this before but here it is again The client that I have been developing a website for has a third party 'optimisin' the site for search engines. He has expressed concerns that there are only 4 entry points to the site when really there should be