MSSQL

**FredFredrickson** · September 15th, 2008, 4:18 PM

So, I just submitted a support ticket, but while I wait, I figured I'd ask around. I'm putting together a quick site that interfaces with my company's MSSQL server. Is it standard not to install PHP with MSSQL support? I assume that installing it isn't a big deal.. right?

**Mark** · September 15th, 2008, 5:21 PM

As far as I know the MSSQL extension only works on Windows

**twirp** · September 15th, 2008, 5:30 PM

Quote:

Originally Posted by Mark

As far as I know the MSSQL extension only works on Windows

PHP: Installing/Configuring - Manual says it can be done by compiling some what not, not sure how well it runs though.

**Mark** · September 16th, 2008, 11:21 AM

Ahh I see it requires a separate library to run in Linux. It might be possible, but you would need to submit a ticket so it can be run by our senior techs

**FredFredrickson** · September 16th, 2008, 12:46 PM

I submitted a ticket and was told it wouldn't be done on my shared account :-(

**puckchaser** · September 16th, 2008, 4:46 PM

That's what you get for messing around with MS.... :-P

**FredFredrickson** · September 17th, 2008, 10:35 AM

To be honest- I didn't exactly have a choice when it came to the platform being used at work. I personally think .net applications are slow as death. All that being said- my boss is letting me use mysql for this- and life is good.

(Say hello to my friend "limit" and his two arguments. T-SQL, do you know my friend "limit"? Of course not. You two should become aquainted...)

H · September 17th, 2008, 11:21 AM

Hehe. I remember missing the hell out of limit when I used MSSQL. Sure, you could limit the result set with "TOP 5", but I can't remember how you did offsets -- it was stupidly tedious if I remember right.

**FredFredrickson** · September 17th, 2008, 12:41 PM

it was...

something like select top(5) * from table where id not in (select top(10) id from table order by id desc) order by id desc

So messy

September 15th, 2008, 4:18 PM	#1 (permalink)
FredFredrickson Senior Member Super #1 Joined in Nov 2003 Lives in New Hampshire 1,260 posts Gave thanks: 3 Thanked 27 times	MSSQL So, I just submitted a support ticket, but while I wait, I figured I'd ask around. I'm putting together a quick site that interfaces with my company's MSSQL server. Is it standard not to install PHP with MSSQL support? I assume that installing it isn't a big deal.. right? __________________

September 15th, 2008, 5:21 PM	#2 (permalink)
Mark Surpass Developer Excelling Contributor Joined in Jan 2004 Lives in Florida Hosted on decc.surpasshosting.com 511 posts Gave thanks: 20 Thanked 78 times	As far as I know the MSSQL extension only works on Windows __________________ Mark Surpass Hosting Developer sɹnoʎ uɐɥʇ ɹǝʇʇǝq sı bıs ʎɯ

September 16th, 2008, 11:21 AM	#4 (permalink)
Mark Surpass Developer Excelling Contributor Joined in Jan 2004 Lives in Florida Hosted on decc.surpasshosting.com 511 posts Gave thanks: 20 Thanked 78 times	Ahh I see it requires a separate library to run in Linux. It might be possible, but you would need to submit a ticket so it can be run by our senior techs __________________ Mark Surpass Hosting Developer sɹnoʎ uɐɥʇ ɹǝʇʇǝq sı bıs ʎɯ

September 16th, 2008, 12:46 PM	#5 (permalink)
FredFredrickson Senior Member Super #1 Joined in Nov 2003 Lives in New Hampshire 1,260 posts Gave thanks: 3 Thanked 27 times	I submitted a ticket and was told it wouldn't be done on my shared account :-( __________________

September 16th, 2008, 4:46 PM	#6 (permalink)
puckchaser He shoots.. He scores! Super #1 Joined in Feb 2007 Lives in A room with no windows. Hosted on SH110 1,448 posts Gave thanks: 46 Thanked 140 times	That's what you get for messing around with MS.... :-P __________________ SH110

September 17th, 2008, 10:35 AM	#7 (permalink)
FredFredrickson Senior Member Super #1 Joined in Nov 2003 Lives in New Hampshire 1,260 posts Gave thanks: 3 Thanked 27 times	To be honest- I didn't exactly have a choice when it came to the platform being used at work. I personally think .net applications are slow as death. All that being said- my boss is letting me use mysql for this- and life is good. (Say hello to my friend "limit" and his two arguments. T-SQL, do you know my friend "limit"? Of course not. You two should become aquainted...) __________________

September 17th, 2008, 11:21 AM	#8 (permalink)
H after g, before i Resident. Joined in Jul 2004 Lives in N,BC,CA 8,087 posts Gave thanks: 48 Thanked 131 times	Hehe. I remember missing the hell out of limit when I used MSSQL. Sure, you could limit the result set with "TOP 5", but I can't remember how you did offsets -- it was stupidly tedious if I remember right.

September 17th, 2008, 12:41 PM	#9 (permalink)
FredFredrickson Senior Member Super #1 Joined in Nov 2003 Lives in New Hampshire 1,260 posts Gave thanks: 3 Thanked 27 times	it was... something like select top(5) * from table where id not in (select top(10) id from table order by id desc) order by id desc So messy __________________

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread: