Freelancers Forum Messages on Monday October 23rd 2006
Re: FN-FORUM: sql question
date posted 23rd October 2006 23:24
On 23 Oct 2006 15:56:17 -0000, pamela @ gconnect [EMAIL REMOVED] wrote:
>
> I have a table where you have a list of bands - January_Band, February_Band
> etc each one points to one of four Price band...
Re: FN-FORUM: sql question
date posted 23rd October 2006 21:44
ah - I see - got you. I will do it in the morning when I am more wide
awake- Pam
----- Original Message -----
From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, Oc...
RE: FN-FORUM: sql question
date posted 23rd October 2006 21:23
I don't know if mysql has stored procedures in the version you're using
- if not then I presum eyou'll be building the sQL string to execute in
php so just code it in in there directly.
-----Original...
Re: FN-FORUM: sql question
date posted 23rd October 2006 21:15
o dear - I forgot to mention that it is php and mysql so what do I use
instead of
Declare @varMonth varchar(50)
Select @varMonth= 'February'
I don't seem to be haviing any luck with Google
Pam...
Re: FN-FORUM: sql question
date posted 23rd October 2006 19:48
instead of "Order by 1 desc" can I uses a name and have something like :-
SELECT Sort_Order as case when @varMonth = 'January' then etc
Pam
----- Original Message -----
From: "Andy Macnaughton-J...
Re: FN-FORUM: sql question
date posted 23rd October 2006 19:44
Ah - that looks just the job. I have never come across "case" in a select
statement before.
Brilliant - Pam
----- Original Message -----
From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
To: [EMAIL...
Re: FN-FORUM: sql question
date posted 23rd October 2006 19:28
It seemed very sensable at the time. I wasn't expecting to have to do a
sort on the Price - it was a late addition. I don't really want to change
the structure at this late stage.
Pam
----- Orig...
RE: FN-FORUM: sql question
date posted 23rd October 2006 19:25
So for each field you'd have;
Declare @varMonth varchar(50)=20
Select @varMonth=3D 'February'
SELECT
case when @varMonth =3D 'January' then
case January_band when =3D 1 then Price_Band_1...
Re: FN-FORUM: sql question
date posted 23rd October 2006 19:10
[EMAIL REMOVED] wrote:
> I have a table where you have a list of bands - January_Band, February_Band
> etc each one points to one of four Price band fields. I want to sort the
> output on the Pric...
Re: FN-FORUM: Powerpoint ~ image problem
date posted 23rd October 2006 18:51
Send it over and I'll have a look. There are several bugs that surface when
you swap between 97 and a later version. I have all "current" versions.
--
+++++++++++++++++++++++++++++++++++++++++++++++...
RE: FN-FORUM: bizare grey border around images used as links
date posted 23rd October 2006 18:25
You normally get that grey dotted border with all text links I think.
Not sure if it's possible to lose it.
Experiment with some properties within
ul#main_menu li a:active { }
I'd suggest border:...
Re: FN-FORUM: opportunity qualification
date posted 23rd October 2006 17:43
I think the main answer is know your trade.
It comes down to experience vs payment
Important part is making sure people can see you know what your doing and
talking about.
I am always flexible and...
Re: FN-FORUM: opportunity qualification
date posted 23rd October 2006 17:26
> From a sales perspective how do most of you designers/developers/other
> technically based freelancers (i) qualify an opportunity to decide if
> it's
> something you want to put time and effort in...
Re: FN-FORUM: bizare grey border around images used as links
date posted 23rd October 2006 17:07
D D Glendinning wrote:
>
> Morning all,
>
>
> I wanted to ask you guys, as I am really confused... Sometimes, not
> all the time (this is what is strange), when you click on the images I
> am using...
Re: FN-FORUM: sql question
date posted 23rd October 2006 17:07
The relevant part of the structure is
Price_Band_1` varchar(20) NOT NULL default '0',
Price_Band_2` varchar(20) NOT NULL default '0',
Price_Band_3` varchar(20) NOT NULL default '0',
Price_Band_4...
FN-FORUM: opportunity qualification
date posted 23rd October 2006 16:58
Afternoon all,
As a sales professional with nearly 20 years experience it's been quite
interesting reading the types of queries/questions and issues that pass
through the forum during the short time...
Re: FN-FORUM: sql question
date posted 23rd October 2006 16:44
[EMAIL REMOVED] wrote:
> I have a table where you have a list of bands - January_Band, February_Band
> etc each one points to one of four Price band fields. I want to sort the
> output on the Price...
RE: FN-FORUM: bizare grey border around images used as links
date posted 23rd October 2006 16:42
Link to the page? Let's have a look.
Jomo
www.DynamicDeveloper.co.uk
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of D D
Glendinning
> Sent: 23 October 2006 13:12...
FN-FORUM: sql question
date posted 23rd October 2006 16:28
I have a table where you have a list of bands - January_Band, February_Band
etc each one points to one of four Price band fields. I want to sort the
output on the Price for a particular month that h...
Re: FN-FORUM: .com addresses
date posted 23rd October 2006 14:35
The reason I had to change the ownership not the hosting, is because my
customer is with BT and they are going through their company they work for
to set it up so need to transfer of ownership to th...
Re: FN-FORUM: .com addresses
date posted 23rd October 2006 14:29
john m wrote:
>
> Which ever company your client uses (eq 123reg or network solutions) to
> host the domain, they will have to send a request for the domain name.
> Rather than you sending the na...
Re: FN-FORUM: .com addresses
date posted 23rd October 2006 14:19
Thanks that was easy
Because I couldn't do it that way with the .co.uk address I didn't bother
looking to see if you could with .com - at least it's free as well, unlike
nominet £11.75 (inc vat)...
Re: FN-FORUM: .com addresses
date posted 23rd October 2006 14:04
Which ever company your client uses (eq 123reg or network solutions)
to host the domain, they will have to send a request for the domain
name.
Rather than you sending the name to them.
You are the...
FN-FORUM: Powerpoint ~ image problem
date posted 23rd October 2006 13:15
Afternoon all,
I've done a very nice powerpoint presentation and it works fine for me
and it would for you too.
However - the client is running office 97 ( Don't go there ) and when
they view the pr...
Re: FN-FORUM: bizare grey border around images used as links
date posted 23rd October 2006 13:03
Re: below
use onfocus="blur()" in your anchor tag.
I wanted to ask you guys, as I am really confused... Sometimes, not
all the time (this is what is strange), when you click on the images I
am usin...
FN-FORUM: bizare grey border around images used as links
date posted 23rd October 2006 12:44
Morning all,
I wanted to ask you guys, as I am really confused... Sometimes, not
all the time (this is what is strange), when you click on the images I
am using for my top navigation bar, you get a...
Re: FN-FORUM: MSSQL Memory Usage
date posted 23rd October 2006 12:37
> What I need to know is if there is a way to configure SQL so as to
> only
> consume a maximum number of memory, so that I don't need to worry
> about its
> memory usage.
Hi Dimitris
SQL Serve...
FN-FORUM: MSSQL Memory Usage
date posted 23rd October 2006 12:26
Hello all, I a new member of your community.
I am facing an issue with SQL Server where it is consuming too much memory
resources. I have tried to find a way to optimise it so that the memory
usage d...
Re: FN-FORUM: .com addresses
date posted 23rd October 2006 11:41
Lorna McArdle - Spinette Designs wrote:
> I know someone here will know
>
> How can I transfer a .com address so it's in my customers name and not mine.
>
> I'm in the process of doing it for the ....
Re: FN-FORUM: .com addresses
date posted 23rd October 2006 11:18
On Mon, Oct 23, 2006 at 10:36:51AM -0000, Lorna McArdle - Spinette Designs wrote:
>
> I know someone here will know
>
> How can I transfer a .com address so it's in my customers name and not mine.
>...
FN-FORUM: .com addresses
date posted 23rd October 2006 11:08
I know someone here will know
How can I transfer a .com address so it's in my customers name and not mine.
I'm in the process of doing it for the .co.uk address so that's easy but
when I searched a...
Re: FN-FORUM: accountants
date posted 23rd October 2006 11:02
Quoting [EMAIL REMOVED] [EMAIL REMOVED]
> [EMAIL REMOVED] wrote:
>
>> I'm looking for recommendations for an accountant. While I'm really
>> interested in some where south of Bristol / north of Taun...
RE: FN-FORUM: Help with HTTPS and the padlock and unsecure items
date posted 23rd October 2006 10:40
>
>Morning all!
>
>I am using SSL on a couple of the pages of my site where the visitor
>is being asked to submit some information.. When this page loads, it
>says "This page contains both secure and...
Re: FN-FORUM: accountants
date posted 23rd October 2006 10:38
[EMAIL REMOVED] wrote:
> I'm looking for recommendations for an accountant. While I'm really
> interested in some where south of Bristol / north of Taunton, if they will
> happily use email im not t...
Re: FN-FORUM: Help with HTTPS and the padlock and unsecure items
date posted 23rd October 2006 10:38
D D Glendinning wrote:
> I am using SSL on a couple of the pages of my site where the visitor
> is being asked to submit some information.. When this page loads, it
> says "This page contains both sec...
FN-FORUM: Help with HTTPS and the padlock and unsecure items
date posted 23rd October 2006 10:33
Morning all!
I am using SSL on a couple of the pages of my site where the visitor
is being asked to submit some information.. When this page loads, it
says "This page contains both secure and unsecur...
RE: FN-FORUM: e-newsletters
date posted 23rd October 2006 08:26
Yes you can use css. However, you need to take a few precautions to ensure
it's displayed properly by all the different mail readers (especially web
based mail readers).
Put your css styles within the...
Re: FN-FORUM: e-newsletters
date posted 23rd October 2006 08:14
Malcolm Izatt wrote:
>
> Can anyone help me please?
>
> I have two clients who want to produce a text and html e-newsletter. Im
> looking for software (mac platform) or a web based facility for
>...
FN-FORUM: e-newsletters
date posted 23rd October 2006 05:46
Hi
I need to build an e-newsletter for a client. I will be supplying a
plain text version but the client also wants an html version to be
posted as well.
Is it best to build the newsletter us...
Re: FN-FORUM: Access question
date posted 23rd October 2006 00:12
Thought so - thanks. Two copies shouldn't be a problem as the data won't
change very often.
Pam
----- Original Message -----
From: "Andy Macnaughton-Jones" [EMAIL REMOVED]
To: [EMAIL REMOVED...
FN-FORUM: accountants
date posted 23rd October 2006 00:02
I'm looking for recommendations for an accountant. While I'm really
interested in some where south of Bristol / north of Taunton, if they will
happily use email im not too concerned.
Instead of (or...
RE: FN-FORUM: Access question
date posted 23rd October 2006 00:01
Simply - no, not unless they're on the same network and as you say have
suitable permissions. Access (AFAIK) doesn't allow "access" via TCP/IP
even using ODBC / OLEDB type of connectivity.
One possib...
|
|