Ok, I have been somewhat tasked here to try and do a web conversion from the idc/htx format of Microsoft to a more portable format. I am looking and using php for my scripting. My current scripts are very simple. Here is my setup.
Microsoft IIS using idc/htx frontend MSSQL backend database All sql queries, inserts, etc.. are handled as stored procedures. IDC files only pass data to the sql server via odbc. As you can see we have setup the sql server to handle all the processing of data. The web server only passes data put into the forms across to the sql server. Here are my questions. 1. What odbc would you recommend under Linux to connect to the mssql server. 2. Where would be a good place to go to get a feel on how I would write the code to pass the variable data over to the sql server. 3. Is this even easily obtainable. Or should I just start trying to re-write the entire site. Also I am including below a sample of what our idc file looks like. *Of course names have been changed to protect the guilty. ;-) Datasource: Contacts Template: view_entry.htx SQLStatement: DECLARE @typesearch varchar(50) +select @typesearch = '%R1%' +if @typesearch = 'name' +Begin +execute sp_corporate_wide_database_search '%name%', '%classification%' +End +if @typesearch = 'company' +begin +execute sp_main_company_search '%name%', '%classification%' +end I am on a tight schedule with this. Otherwise I would be only digging into any manual I could find first. Thanks, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
