http://www.dreamsoft.co.in/forum/index.php en Tue, 26 Jul 2011 06:12:12 -0400 Tue, 26 Jul 2011 06:12:12 -0400 Dreamsoft Technologies | Forums Phorum 5.1.25 60 http://www.dreamsoft.co.in/forum/read.php?3,226,226#msg-226 steve88 What we do? http://www.dreamsoft.co.in/forum/read.php?3,226,226#msg-226 Tue, 26 Jul 2011 06:12:12 -0400 http://www.dreamsoft.co.in/forum/read.php?4,7,7#msg-7 dream
This is the most common headache for all PHP-Developers.

"Warning: Cannot modify header information - headers already sent"

A simple solution would be to add:
obstart();

function at the top of the PHP page.]]> PHP http://www.dreamsoft.co.in/forum/read.php?4,7,7#msg-7 Tue, 22 Apr 2008 22:29:52 -0400 http://www.dreamsoft.co.in/forum/read.php?14,5,5#msg-5 ram
It's my first POST here and hope to do it right.
During my last project i found some difficulty in converting an asp.net project from MS Sql database to Mysql.

Here are list of some differences that i wanted to share with you all:-

a) ->In MS Sql
add key="DBConnectionString" value="workstation id=workstationID;packet size=4096;user id=userID;data source=SourceAddress;persist security info=True;initial catalog=name;password=pwd"

->In Mysql
add key="DBConnectionString" value="Driver={MySQL ODBC 3.51 Driver}; Server=localhost;Database=databasename;uid=userID;pwd=mypassword;option=3"

b) ->In MS Sql
Imports System.Data.SqlClient

->In Mysql
Imports System.Data.Odbc

c) ->In MS Sql
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand

->In Mysql
Dim myConnection As OdbcConnection
Dim myCommand As OdbcCommand

If you are using StoredProcedures then here are the list of diffrences between MS sql and Mysql:-

d) ->In MS Sql
Dim DsLogin As New DataSet
OpenDBConnection()
Dim myDataAdapter As New SqlDataAdapter("spGetLoginInformation", OranjConnString)
myDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
Dim ParmUserName As New SqlParameter("@UserName", SqlDbType.VarChar, 15)
ParmUserName.Value = xUserName
myDataAdapter.SelectCommand.Parameters.Add(ParmUserName)
Dim ParmPwd As New SqlParameter("@Pwd", SqlDbType.VarChar, 15)
ParmPwd.Value = xPassword
myDataAdapter.SelectCommand.Parameters.Add(ParmPwd)
myDataAdapter.Fill(DsLogin, "LoginInfo")
CloseDBConnection()

->In Mysql
Dim DsLogin As New DataSet
OpenDBConnection()
Dim myDataAdapter As New OdbcDataAdapter("call spGetLoginInformation(?,?)", OranjConnString)
myDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
Dim ParmUserName As New OdbcParameter("?at_UserName", OdbcType.VarChar, 15)
ParmUserName.Value = xUserName
myDataAdapter.SelectCommand.Parameters.Add(ParmUserName)
Dim ParmPwd As New OdbcParameter("?at_Pwd ", OdbcType.NVarChar, 15)
ParmPwd.Value = xPassword
myDataAdapter.SelectCommand.Parameters.Add(ParmPwd)
myDataAdapter.Fill(DsLogin, "LoginInfo")
CloseDBConnection()

Note(Mysql):-call spGetLoginInformation(?,?)- No. of question marks equal to number of variables.

e) ->In MS Sql
fieldname = "ISNULL( Max(iuserID ) ,0) + 1 "

->In Mysql
fieldname = "IFNULL(Max(iuserID ),0)+1"

Find more in next...]]> .NET http://www.dreamsoft.co.in/forum/read.php?14,5,5#msg-5 Mon, 03 Mar 2008 06:35:17 -0500 http://www.dreamsoft.co.in/forum/read.php?4,4,4#msg-4 azy
When I was told by my boss that I would have to study PHP for my upcoming project, I said to myself “new language… its gonna take months…”, But when I started it off, it went like a breeze.

Yes, PHP (PHP Hypertext Processor), is one of the easiest server side scripting languages to learn. What has it got?... Hundreds of functions (used a few hundred myself ), Easy session and cookie handling, Object Oriented Programming Concepts (PHP5) and loads more… the best part is, PHP syntax is just like that of C and PERL. The second best is that it can be embedded anywhere in your HTML code… yes, “ANYWHERE”.

W3Schools.com (Kindergarten of all web developers) is the 1st place I went to check it out. 2 days and I started with manual coding. In a week’s time, I was half way through it. All you need to get started in PHP is a server (I use APACHE) and a text editor (Like notepad or better, a web development software like Dreamweaver ). And if you know C or PERL, you are half way through already!!! . You can start off if you like web development ( Play with it a little, making new things and stuff ).. make it a part time job ( PHP Freelancers are IN DEMAND ) or make a career out if it. It is currently rated the 4th most popular language after Java, C and Visual Basic… and its growing FAST!!!

Please give your comments and suggestions regarding this tiny article… (MY first ever… so there could be mistakes… Please point them out). And I invite one and all to continue this post giving your views, or articles of your own. Looking forward to type in more.

Next article on 7th March...

Regards

Abdul Aziz Sulaiman]]> PHP http://www.dreamsoft.co.in/forum/read.php?4,4,4#msg-4 Fri, 29 Feb 2008 01:24:22 -0500 http://www.dreamsoft.co.in/forum/read.php?2,3,3#msg-3 dream
I would like to announce a product that we are developing called Dreamsoft Publisher Max. Its a subscription management system for publications, magazines, newspapers etc.

The feature list is as follows:
Feature List:

1> User Friendly software

2> Multiple Publications in multiple languages supported

3> Multiple Publishers supported

3> Subscription Management

4> Manage active subscribers and expired subscribers

5> Convert expired subscribers to active subscribers

6> Manage contacts, addresses

7> Unlimited address storage capability

8> Print Addresses to Envelopes or Labels sorted by Area, Pin or Country

9> Powerful search, allowing contacts, subscribers to be quickly found

10> Backup and Restore data

11> Notification of Expired subscribers in the current month or a date range

12> Task Management

13> Demographics

14> Intuitive Wizards for tasks such as setting up the software, taking
backups, restoring backups

15> Microsoft UI Guidelines maintained to ensure user comfort.

16> Data entry made ergonomic to reduce strain on the user.


Screenshots and other material will be made available soon on this page. A demo will be posted on this for public testing as soon.

Support Team,
Dreamsoft Technologies.]]> Upcoming Products http://www.dreamsoft.co.in/forum/read.php?2,3,3#msg-3 Sun, 10 Feb 2008 21:41:58 -0500