Freelancers Forum Messages on Sunday January 21st 2007
RE: FN-FORUM: whitespace in IE
date posted 21st January 2007 23:16
Apparently IE7 has a minimum dialog size limitation, which is to do with the
user being able to read the address bar more easily:
http://blogs.msdn.com/ie/archive/2006/08/25/719355.aspx
- It's 250...
FN-FORUM: "trade" magazines
date posted 21st January 2007 22:35
I'm planning on having a chat with my accountant tomorrow about subscribing
to magazines through my ltd. Does any one else do this? Or have any
recommendations for magazines? The only one I buy regula...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 22:33
I had a feeling the cartesian product would be too great.
having looked at it a little more in depth there is a better solution to do
one at a time and keep it simple
thanks all
andrew
----- Ori...
FN-FORUM: whitespace in IE
date posted 21st January 2007 21:46
http://www.meriyatra.in/test-file.htm
Can someone help me find the reason for white space on the calendar
page in IE, when you click on link on this page.
There is no white space in firefox.
ramni...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 20:34
On Sunday 21 Jan 2007 5:21 pm, Punters Power wrote:
> AND
You'll have to wait a bit, mate. Quantum computers are still not widely=20
available enough for you to do=20
$value=3D"1 AND 2 AND 3";
--=...
Re: FN-FORUM: Which bank?
date posted 21st January 2007 20:08
On Saturday 20 Jan 2007 11:47 pm, [EMAIL REMOVED] wrote:
> Quoting Dom Latter [EMAIL REMOVED]
> > On Friday 19 Jan 2007 11:02 pm, [EMAIL REMOVED] wrote:
> >> Saying that, I feel more secure with my Fi...
RE: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 16:51
I can see the seed and increment properties however i cannot edit them? any
ideas?
_______________________________
James,
If the 'Identity Increment' and 'Identity Seed' fields are not enabled, ma...
RE: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 16:45
Strings up to 8000 characters use a varchar unless you ened to store
unicode text in which case nvarchar (and it's only 4000 characters
then). This will create a variable length field/column. If you w...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 16:30
AND
Andrew
----- Original Message -----
From: "James Herrington" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, January 21, 2007 5:09 PMand > basically AND selects only the
records that meet a...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 16:20
I think yu have answered the question I was having difficulty establishing
the differecne between defining the values as an array and then looping
through each one within the query or simply hand wr...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 16:18
Do you know what condition you require? OR or AND?
basically AND selects only the records that meet all the conditions set
whereas OR selects the records that meet one or more of the conditions.
Ja...
Re: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 16:09
Thanks guys, sorted it out now, the properties were locked because i had set
the column as a uniqueidentifier instead of an int. like i said i havent
used SQL Server before (and only am now because...
RE: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 15:54
Hi,
On the Object Explorer, right click on the table and click Modify
Then select the column in the table - dbo.tablename tab and you'll get
all the column properties
Go down to "Identity Specific...
RE: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 15:52
>> I'm using SQL Server Express Edition and was wondering if anyone here
knew
how to create an autonumber start at a set number as opposed to the default
0, for example start counting from 1000 inst...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 15:48
> $values =3D array(1,2,3);
> $values_sql =3D implode(',',$values);
> $sql =3D "SELECT * FROM tbl_value_indo AS pi WHERE value IN ($values_s=
ql)";
Ooops! That won't work if you want AND, not OR......
Re: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 15:44
I can see the seed and increment properties however i cannot edit them? any
ideas?
Thanks
James...
RE: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 15:44
I'ts;
Create table (ColumnIwantToAutoIncrement int identity(startingvalue,
incrementvalue)
E.g.,
Create table (uid int identity(50, 5)=20
will count up in 5's starting at 50.
HTH cheers
Andy
---...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 15:39
I think you might need an OR condition in your select statement. Are you
trying to find all records where the 'value' field could be one of three
values declared by you? For example
SELECT supplier...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 15:31
> if I have an array the query
>
> FROM tbl_value_info as pi
> WHERE value=3D "'.$value.'"';
>
> wont work because I need AND or is there a way around this?
You need a query like:
FROM tbl_v...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 15:26
I may well be wrong but cant you create a for loop to general the WHERE part
of the SELECT statement? Am not an expert in PHP but this should be doable
e.g.
string whereSection = "WHERE ";
For(in...
RE: FN-FORUM: Autonumber in sql server
date posted 21st January 2007 15:18
If you have SQL Server Management Studio Express, in there when you set an
Identity column and there is an option to specify a seed and an increment
underneath. Apologies for a vague answer!!!
---...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 15:15
I think the array is correct howver the query in using $value and I don't
think the query wil work with an array or will it?
lest say i define the variable
$variable="1";
this is fine becuase ther...
FN-FORUM: Autonumber in sql server
date posted 21st January 2007 14:58
I'm using SQL Server Express Edition and was wondering if anyone here knew
how to create an autonumber start at a set number as opposed to the default
0, for example start counting from 1000 instead...
Re: FN-FORUM: MySQL PHP Query
date posted 21st January 2007 14:44
I don't really understand what your trying to do here but from what you said
it sounds like you need an array and then a for loop to iterate through the
array elements!
Might be way off the mark bu...
FN-FORUM: MySQL PHP Query
date posted 21st January 2007 14:35
little teaser that shouldn't be any bother having I have a block
I have a query that current;y is just one value '1' however I now need to
add more values so that it is using 1,2,3
because I am usi...
|
|