Freelancers Forum Messages on Wednesday May 14th 2008
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 22:26
On Wednesday 14 May 2008 19:44:39 Neil Caunt wrote:
> SELECT
> CASE WHEN SIGN(id - 5) > 0 THEN 'next' ELSE 'prev' END AS dir,
> CASE when sign(id - 5) > 0 THEN MIN(id) ELSE MAX(id) END AS id
> FROM...
RE: FN-FORUM: Web magazine Viewers
date posted 14th May 2008 22:12
Ah thanks Lee,
Had a blank mind on what else to search.
John.
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Lee
Rickler
Sent: 14 May 2008 22:59
To: FN-FORUM / [EM...
RE: FN-FORUM: Web magazine Viewers
date posted 14th May 2008 22:09
I'll have a look at that.
Thanks.
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
[EMAIL REMOVED]
Sent: 14 May 2008 22:53
To: FN-FORUM / [EMAIL REMOVED]
Subject: Re:...
Re: FN-FORUM: Web magazine Viewers
date posted 14th May 2008 21:20
Is that what you're looking fo?
I thought it was something else.
google flash page turn you'll get loads of results.
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Develop...
Re: FN-FORUM: Web magazine Viewers
date posted 14th May 2008 21:14
John Ainsworth wrote:
> Hi All
>
> Can any of you suggest a good electronic magazine viewer?
>
> I'd rather buy one off the shelf than send it to someone like
> www.webmags.co.uk ?
>
> Cheers, John....
RE: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 21:02
Ben Johnson (Neogic) F wrote:
> +1 sIFR - We normally use sIFR for non-standard heading fonts - good =
thing
> is it transparently replaces standard HTML text with a fancy font =
version,
> which is g...
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 19:46
On 14/05/2008 21:12, Ben Johnson (Neogic) F wrote:
>
> +1 sIFR - We normally use sIFR for non-standard heading fonts - good thing
> is it transparently replaces standard HTML text with a fancy font v...
RE: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 19:34
John Deaville wrote:
> I want to write some headers using an ornate font - the page is =
supposed
to
> look like a plush restaurant menu - are there any ornate fonts used on
both
> mac and pcs - so I...
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 19:10
On 14/05/2008 20:31, James Herrington wrote:
>
> John Deaville wrote:
>> I want to write some headers using an ornate font - the page is
>> supposed to
>> look like a plush restaurant menu - are the...
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 19:04
As I said - sifr - http://www.mikeindustries.com/blog/sifr/
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for over 11 years
John Deaville wrote:
>
>
> Yep -...
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 19:02
Interesting
I wont use it this time, because they are more interested in using a
specific look and font so I shall just use graphics, but will keep it in
mind for future
Thanks (and Lee for the...
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 18:51
John Deaville wrote:
> I want to write some headers using an ornate font - the page is supposed to
> look like a plush restaurant menu - are there any ornate fonts used on both
> mac and pcs - so I ca...
FN-FORUM: Web magazine Viewers
date posted 14th May 2008 18:51
Hi All
Can any of you suggest a good electronic magazine viewer?
I'd rather buy one off the shelf than send it to someone like
www.webmags.co.uk ?
Cheers, John....
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 18:51
Yep - I thought as much - I shall just use graphics and alt tags
Incidentally - is there any way of embedding a font in a page - similar to
the way flash player does? So that the user sees that fon...
Re: FN-FORUM: CSS Style Help
date posted 14th May 2008 18:42
Good call.
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for over 11 years
gareth coxon wrote:
>
> Fair point Lee, after looking at the code and realising I'...
Re: FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 18:42
For a website i assume?
Use sifr?
Besides the normal, arial, helvetica etc you won't get anything 'special'.
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for...
Re: FN-FORUM: CSS Style Help
date posted 14th May 2008 18:35
Fair point Lee, after looking at the code and realising I'm not Neo
(see the Matrix) or a css expert I've decided to leave it alone!
I thank everyone for their suggestions though.
Many thanks
Gare...
FN-FORUM: Common ornate font to use on website
date posted 14th May 2008 18:34
Hello
I want to write some headers using an ornate font - the page is supposed to
look like a plush restaurant menu - are there any ornate fonts used on both
mac and pcs - so I can use text rather th...
RE: FN-FORUM: osCommerce install error
date posted 14th May 2008 17:16
I believe it's 5
--------------------------------
Are you using PHP4 or 5 on your server?
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for over 11 years
A...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 17:06
Hi Rob,
This little problem intrigued me as I was sure it had to be possible using
only a single select query with no subselects or unions.
A quick search turned up this page:
http://www.xaprb.com/...
Re: FN-FORUM: Not my day for tech success!!
date posted 14th May 2008 16:38
Yes, I should say so too - the bare faced cheek :)
Tom Wilson wrote:
> Does your warranty not have a assidental damage clause ?
>
>
>
> (i do apologize for any offense that bad bad joke caused)
>...
Re: FN-FORUM: Not my day for tech success!!
date posted 14th May 2008 16:30
Boom boom ! (or Bum Bum rather)
On 14/5/08 17:47, "Tom Wilson" [EMAIL REMOVED] wrote:
>
> Does your warranty not have a assidental damage clause ?
>
>
>
> (i do apologize for any offense that...
Re: FN-FORUM: Not my day for tech success!!
date posted 14th May 2008 16:09
Does your warranty not have a assidental damage clause ?
(i do apologize for any offense that bad bad joke caused)
On Wed, May 14, 2008 at 5:39 PM, Rob Colton [EMAIL REMOVED] wrote:
>
> After the...
FN-FORUM: Not my day for tech success!!
date posted 14th May 2008 16:00
After the XP SP3 fault, I went to the Post Office to send some letters. Put
my phone in my back pocket. Came home and sat on the bloody thing. Screen
cracked. Bum.
I am going to spend the rest of the...
Re: FN-FORUM: Generic Host Process for Win32 Services
date posted 14th May 2008 15:56
I have indeed considered it. Not sure if the license will work as it is a
OEM license tied to the machine, but worth a go I think
R
On 14/5/08 17:19, "Nick Smart" [EMAIL REMOVED] wrote:
>
> Rob C...
Re: FN-FORUM: Generic Host Process for Win32 Services
date posted 14th May 2008 15:41
Rob Colton wrote:
> This machine is an old P4 machine, I have to admit it has never been as
> stable as I would expect, even for Windows and I probably ought to dontate
> it to someone and get a prope...
Re: FN-FORUM: Generic Host Process for Win32 Services
date posted 14th May 2008 15:36
>> Rob Colton wrote:
>>> Installed XP SP3 last night, restarted this morning and keep getting and
>>> error dialogue
>>>
>>> Generic Host Process for Win32 Services has encountered a problem and nee...
Re: FN-FORUM: Generic Host Process for Win32 Services
date posted 14th May 2008 15:28
This machine is an old P4 machine, I have to admit it has never been as
stable as I would expect, even for Windows and I probably ought to dontate
it to someone and get a proper machine. But I only us...
Re: FN-FORUM: Generic Host Process for Win32 Services
date posted 14th May 2008 15:19
Rob Colton wrote:
> Installed XP SP3 last night, restarted this morning and keep getting and
> error dialogue
>
> Generic Host Process for Win32 Services has encountered a problem and needs
> to close...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 15:16
On Wednesday 14 May 2008 16:41:44 Tom Wilson wrote:
> I'm taking that as agreement that 1 is better than 3 separate.
Hah! I'm afraid you signed up for the full half hour. My answer is
whatever's m...
Re: FN-FORUM: osCommerce install error
date posted 14th May 2008 15:10
Are you using PHP4 or 5 on your server?
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for over 11 years
Ashley Harvey wrote:
> Hello,
>
> I'm trying to insta...
Re: FN-FORUM: CSS Style Help
date posted 14th May 2008 15:10
It looks the same because it uses the same class.
You'll need to add a new id/ class to the stylesheet, assign preferences
to that id/ class then find the comments section in the template and add
th...
FN-FORUM: Generic Host Process for Win32 Services
date posted 14th May 2008 15:02
Installed XP SP3 last night, restarted this morning and keep getting and
error dialogue
Generic Host Process for Win32 Services has encountered a problem and needs
to close. We are sorry for the inco...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 14:57
Thanks for all the advice on this. I think I have it figured now.
On 14/5/08 15:36, "Dai Williams" [EMAIL REMOVED] wrote:
>
> Dom Latter wrote:
>> On Wednesday 14 May 2008 14:57:51 Dai Williams wr...
RE: FN-FORUM: osCommerce install error
date posted 14th May 2008 14:48
HI,
Have done but haven't had any response.
Tried uploading the files again and have downloaded everything from the
osCommerce website again but still no joy.
Kind Regards
Ashley Harvey
-----Ori...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 14:03
refactored to perfection ;) and well under 0.200 seconds
I'm taking that as agreement that 1 is better than 3 separate.
On Wed, May 14, 2008 at 3:24 PM, Dom Latter [EMAIL REMOVED] wrote:
>
> On Wed...
RE: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 13:57
Dom Latter wrote:
> On Wednesday 14 May 2008 14:57:51 Dai Williams wrote:
>
>> Page.php?id=8&next=1 (nextlink)
>> Page.php?id=8&prev=1 (previous link)
> Except if you are at the beginning or end of t...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 13:46
On Wednesday 14 May 2008 15:15:38 Tom Wilson wrote:
> I like consolidating queries instead of firing off more queries for
> data that already could already be retrieved.
Fair enough; try this for si...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 13:03
'It's flawed in that you need to work around what happens when you're at
one end of the list.'
The workaround code would be simpler that firing off another query and
quicker. The query does exactly w...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 12:44
On Wednesday 14 May 2008 14:25:12 Graham Stark wrote:
> I haven't been following this one, but given what I understand the
> problem to be, Tom's solution looks quite elegant. The problem is that
It...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 12:37
Sorry i assumed folk would get the point with 'select *' could be
replaced with a select for the exact data you require but maybe not.
I like consolidating queries instead of firing off more queries...
Re: FN-FORUM: CSS Style Help
date posted 14th May 2008 12:32
Thank you everyone for your help, i'm looking into the options
suggested and apprecitate your time taken.
many thanks!
gareth
On 14 May 2008, at 13:21, Owen Smith wrote:
>
> Hi
>
>
> You might wa...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 12:31
On Wednesday 14 May 2008 14:57:51 Dai Williams wrote:
> Page.php?id=3D8&next=3D1 (nextlink)
> Page.php?id=3D8&prev=3D1 (previous link)
>
> Then the page checks for next and prev params and query does...
RE: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 12:19
Graham Stark wrote:
> On Wed, 2008-05-14 at 11:33 +0000, Dom Latter wrote:
> Don't know why everyone wants to make this so complicated.
In the spirit of "more than one way to do it", I have to say I...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 11:47
On Wed, 2008-05-14 at 11:33 +0000, Dom Latter wrote:
> On Wednesday 14 May 2008 12:31:38 Tom Wilson wrote:
> > Try this,
> >
> > (select * from news where ID > UNION
> > (select * from news where ID...
RE: FN-FORUM: CSS Style Help
date posted 14th May 2008 11:43
Hi
You might want to fiddle with this bit of css
#comment {
width: 400px;
height: 200px;
border: 1px solid #333;
}
As that's the wrapper for your comments, bu its too early for my brain to do
CSS...
Re: FN-FORUM: osCommerce install error
date posted 14th May 2008 11:41
try the oscommerce forum!
file error or permissios on the server usually apache
----- Original Message -----
From: "Ashley Harvey" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, May 14, 2008...
Re: FN-FORUM: CSS Style Help
date posted 14th May 2008 11:36
On 14 May 2008, at 13:03, gareth coxon wrote:
>
> Morning All
>
> I have a blog on my website (will my website is a blog really) and
> when people are leaving comments the style is the same as the...
RE: FN-FORUM: CSS Style Help
date posted 14th May 2008 11:32
> The website developer who was helping me with CSS (of which I know
> very little, if nothing about) is on holiday until 28th May. could
> anyone give me a pointer or help on the code I need to put i...
FN-FORUM: osCommerce install error
date posted 14th May 2008 11:31
Hello,
I'm trying to install osCommerce but it keeps coming up with a 500 error
message and when I check the error logs it says:
"[Wed May 14 10:28:00 2008] [notice] mod_fcgid: call
/home/american/...
Re: FN-FORUM: Online service for sending out bulk emails
date posted 14th May 2008 11:28
I use 1shoppingcart.com and Aweber
very reliable and good mailing list programmes .
We have also developed an web based solution for sending out the emails from
out server ( not really bulk but a c...
FN-FORUM: CSS Style Help
date posted 14th May 2008 11:24
Morning All
I have a blog on my website (will my website is a blog really) and
when people are leaving comments the style is the same as the article
itself so its looks like one long string of te...
Re: FN-FORUM: Online service for sending out bulk emails
date posted 14th May 2008 11:16
Quoting Paul Cooper [EMAIL REMOVED]
>
> Hi
>
> A client wants to send out bulk emails. I haven't done this in a
> while. I think this was the site I used but it was over 5 years ago
> ...
>
> http:...
Re: FN-FORUM: OSCommerce Gallery
date posted 14th May 2008 11:13
I guess I'm looking for something that I can display with
Slimbox/Lightbox, which I should be able to do myself. In that case I
just need a admin module for uploading images in to a directory withou...
FN-FORUM: Online service for sending out bulk emails
date posted 14th May 2008 11:05
Hi
A client wants to send out bulk emails. I haven't done this in a
while. I think this was the site I used but it was over 5 years ago
...
http://www.postmaster.co.uk/
Can someone recommend a go...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 10:54
On Wednesday 14 May 2008 12:31:38 Tom Wilson wrote:
> Try this,
>
> (select * from news where ID UNION
> (select * from news where ID >= $id order by ID ASC LIMIT 2)
>
> This returns the rows your af...
Re: FN-FORUM: OSCommerce Gallery
date posted 14th May 2008 10:48
Never bothered to use them as I always develop my own.
Flash/ CSS or Javascript based?
Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for over 11 years
John D...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 10:29
Ignore who? Did somebody say something?
:)
>
> ....in which
> case, just ignore me. *grin*.
>
> Alex
> http://www.ozbon.com
>
--
Dominic Raywood
Rubicon Computer Services Limited
W: http:/...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 10:25
Well, maybe you can chase a few contracts before you resign? It won't
be that easy with 8 weeks notice though. I can't quite remember that
far back, but I was probably on one month notice. I got...
FN-FORUM: OSCommerce Gallery
date posted 14th May 2008 10:20
Anyone know of any integrated photo galleries for OSCommerce?
There are a couple in the contributions, but they look like abandonware
and don't allow for admin based uploads.
JD
--
John Dickens...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 10:10
Quoting Anthony Cartmell [EMAIL REMOVED]
>
>> Its hard hard work to get going from scratch so go careful.
>
> +1, if you can't afford to support yourself without much income for at
> least a couple o...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 09:59
> Its hard hard work to get going from scratch so go careful.
+1, if you can't afford to support yourself without much income for at
least a couple of years, you'll need to build up your own freela...
Re: FN-FORUM: Website development pricing query
date posted 14th May 2008 09:57
Hi Is,
I think difficult to quote a day rate because PM often does not =20
require a whole day.
Either a project rate based on x number of hours or an hourly rate =20
would give a customer the feeli...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 09:53
Try this,
(select * from news where ID = $id order by ID ASC LIMIT 2)
This returns the rows your after and the surrounding two rows either
side, so if $id=8 it will return rows 8,...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 09:49
From: "Dan B" [EMAIL REMOVED]
: Hi guys,
:
: I am a software developer and have worked at the same company for
: about a year now but I am the kind of person that thrives on change
: and new projects,...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 09:48
On 14/05/2008 10:37, Dan B wrote:
> Hi guys,
>
> I am a software developer and have worked at the same company for
> about a year now but I am the kind of person that thrives on change
> and new proj...
FN-FORUM: Website development pricing query
date posted 14th May 2008 09:45
Hi,
I'd be grateful for a bit of advice - I'm a copywriter, writer and
promotions/communications bod by trade but have been asked to project
manage the development of a website for a charity organisa...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 09:38
Hi Dan
Apart from the business admin aspects another thing you need to ask yourself
is are you of the right mentality to go out and get work. Maybe even cold
calling companies in the first few months...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 09:25
I'd say do it, Dan, but do it carefully, a step at a time. Build up a
client base that you can rely on and leave your job in stages!
The competition is fierce, and there is a lot to learn about thi...
Re: FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 09:20
Quoting Dan B [EMAIL REMOVED]
>
> Hi guys,
>
> I am a software developer and have worked at the same company for
> about a year now but I am the kind of person that thrives on change
> and new projec...
FN-FORUM: contracting and how to take the leap..!
date posted 14th May 2008 08:59
Hi guys,
I am a software developer and have worked at the same company for
about a year now but I am the kind of person that thrives on change
and new projects, especially developing a system from th...
Re: FN-FORUM: So ... what did you do today?
date posted 14th May 2008 08:36
> On 14/05/2008 01:42, Lee Rickler wrote:
>>
>> Yesterday was probably the most annoying, frustrating and pointless day
>> ever.
>>
>> Today, however, I ...
>>
>> Finished up an online store
>> Develo...
Re: FN-FORUM: So ... what did you do today?
date posted 14th May 2008 08:27
On 14/05/2008 01:42, Lee Rickler wrote:
>
> Yesterday was probably the most annoying, frustrating and pointless day
> ever.
>
> Today, however, I ...
>
> Finished up an online store
> Developed a...
RE: FN-FORUM: Payment gateways
date posted 14th May 2008 08:08
Thanks Guys=20
Appreciated
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Juraj
Seffer
Sent: Tuesday, 13 May, 2008 8:41 AM
To: Ashraf Aswat
Subject: Re: FN-FORUM: Paym...
RE: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 06:21
> But I don't know an easy way to do this without testing each higher and
> lower number until I find a valid ID. (Some articles are deleted so
> there is not a continuous sequence.
>
> I recall read...
Re: FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 06:21
Rob Colton wrote:
> Hi
>
> I have a simple news page which has its content stored in a DB as separate
> articles. When I pull up a news article into this template I want to be able
> to show a link to...
Re: FN-FORUM: So ... what did you do today?
date posted 14th May 2008 00:20
Today was my pointless day. I wandered about the house, it was too hot and
sticky here, tried to tidy my desk and other dross tasks. Anything rather
than sit in a hot office and do work.
Still tomorr...
FN-FORUM: Choosing the next record in MySQL DB
date posted 14th May 2008 00:18
Hi
I have a simple news page which has its content stored in a DB as separate
articles. When I pull up a news article into this template I want to be able
to show a link to the next news story and th...
FN-FORUM: So ... what did you do today?
date posted 14th May 2008 00:04
Yesterday was probably the most annoying, frustrating and pointless day
ever.
Today, however, I ...
Finished up an online store
Developed a bit of another, smaller, online store
Created a new seaso...
|
|