NYCPHP Meetup

[Ben Sgro]

Hello Justin,

Yeah, as far as I can tell, Dave is correct. The source I built was for 
linux. I don't see if building for windows. (But I haven't tried)

Thanks though for your feedback.

I'm hoping someone can provide some additional help.

This is REAL problem, because we worked hard to get PHP accepted as a 
development language for enterprise applications
by our client. And now we are having all these problems.

Its a fact that our client's requirements is that we use SQL-SERVER, and 
with Zend And PHP on windows, this is proving
to have many limitations. Its a real shame that Zend hasn't improved the 
pdo or offer something other than pdo for windows/linux.

I'm not a windows/ms user, but our clients are.

Anyways, incase anyone wants to know how I've temporarily solved this 
problem.

Basetable:
...
XmlContent
TextContent

View:
...
TextContent

All my controllers point to my View table. Whenever the TextContent 
field is updated, a SQLSERVER trigger is run
that updates the basetable's XmlContent field.

Its kinda hacky, but it works.

- Ben

PS: Its silly that Zend does a SELECT * for fetchAll() and fetchRow(). 
You should be able to override w/a list of fields (I dont want to write 
my own SQL).

Justin Dearing wrote:
> On Wed, Jun 4, 2008 at 2:59 PM, David Hauenstein
> <davehauenstein at gmail.com> wrote:
>   
>> FreeTDS is a library that allows Linux to talk to mssql. Ben needs his app
>> to work on a production server that runs Windows, so FreeTDS has nothing to
>> do with the solution, unfortunately.
>>     
>
> Dave,
>
> I think I've been making false assumptions for a couple of years now.
> I always thought that the mssql_foo() functions and the mssql pdo
> functions used FreeTDS even on windows. I can't find a definite answer
> online so can you point out a source that confirms I am correct or
> incorrect in my assumption.
>
> Ben,
>
> Assuming I am incorrect I have to say sorry I'm of no help in this regard.
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
>