Search results for query: *

[date] [error] [client 127.0.0.1] Premature end of script headers: php.exe Upgraded to Apache 2.0.52 and PHP5 and previously working code gives the above error. Even a simple <? echo "test"; ?> gives this error. Is this a php.ini problem or a httpd.conf error? I know that everything in...

So the root password was set to something that is currently unknown, how can I go about resetting it? I can see in the mysql database, ie the following path C:/program files/mysql/data/mysql in the file user.MYD that the user root appears to have password root but it does not seem to work...

[Fri Oct 05 22:08:15 2007] [error] [client 127.0.0.1] Premature end of script headers: php.exe Just upgraded to Apache 2.0.52 and PHP5 and previously working code gives the above error. Even a simple <? echo "test"; ?> gives this error. Is this a php.ini problem or a httpd.conf error? I...

I have a datagrid which uses an TemplateColumn due to formatting restrictions. Inside this I wish to have an image link that when clicked fires a sub() and passes in the particular MyID for that record. Usually I can achieve this with the <asp:EditCommandColumn> and setting the OnEditCommand of...

So if a view exists with something like CREATE VIEW vwFoo AS SELECT tblA.*, tblB.x, tblB.y, tblB.x FROM ... and elsewhere in business logic or stored procedure you have something like SELECT * FROM vwFoo if you actually have altered tblA then you need to rebuild the VIEW, why on earth is this?

I have a stored procedure of the general form below. Essentially 3 cursors which each perform INSERT and UPDATE statements dynamically. If I wanted to add in a "BEGIN TRANSACTION" statement where would I place this so that I don't get any of those Transaction count after EXECUTE indicates that...

Without explicitly passing something in the arg list of a procedure how can you access a RETURN value, for example create sp1 as begin if exists (select foo from foobar) begin return 1 end else begin return 0 end end go create procedure sp2 as begin...

How do I control the styling for an <option> tag? I seem to be able to change its colour but not its font size or weight? Any ideas? <style type="text/css"> .OrgRole { font-family: tahoma, verdana, sans-serif; font-weight: bold; } .OrgUser { font-family: tahoma, verdana, sans-serif...

Do transactions always have to managed in a cascading fashion ie BEGIN TRANSACTION INSERT INTO tblA .... IF @@ERROR <> 0 BEGIN ROLLBACK TRANSACTION RETURN 1 END ELSE BEGIN INSERT INTO tblB .... IF @@ERROR <> 0 BEGIN RETURN 1 ROLLBACK TRANSACTION END ELSE...

MyDropDown = System.Web.UI.WebControls.DropDownList MyReader = System.Web.UI.WebControls.SqlDataReader MyDropDown.Items.Add(New ListItem(MyReader("Value1"), MyReader("Value2"))) I have a dropdownlist that I want to add values to. The problem is that the values in question have HTML in them. So...

I have a table as follows : Foo | Position a 1 b 1.1 c 1.1.1 d 1.2 e 1.2.1 f 1.2.1.1 g 1.2.1.2 h 1.2.1.3 i 1.2.1.3.1 I want to SELECT from this table but the recordset would already achieve my indentation for me. So each digit in the Position field will be replaced by '&nbsp;' ie Foo &nbsp;a...

declare @foo varchar(50) set @foo = '1.1.1.1' select replace(@foo, '1.1','1.2') This gives me 1.2.1.2 as it replaces all occurrences of 1.1 in @foo, how would I only replace the beginning of @foo with 1.2? I will always know the length of the string to replace if that helps?

I'd like to use a recursive function to calculate the depth of each Role as it is added. So a new field called depth will be added to the table tblOrganisationRoleOrgChart. Given these two tables tblOrganisationRoles =========================== OrganisationRoleID int | OrganisationID int |...

I have three tables, I am looking to get a dendritic structure of organisation roles and who they report to. A sample might be tblOrganisationRoles =========================== OrganisationRoleID int | OrganisationID int | Role varchar 1 1000 CEO 2 1000...

I have three tables, I am looking to get a dendritic structure of organisation roles and who they report to. A sample might be tblOrganisationRoles =========================== OrganisationRoleID int | OrganisationID int | Role varchar 1 1000 CEO 2 1000...

Objects that I have created from classes, do they need to be destroyed (how is this done??) or is garbage collection an issue in PHP?

1) How do I remove borders from a table in CSS? Tried border:0px; but while that removes the outer border, my table rows have colours and the grids are visible in white. 2) How do you center align a table via CSS? I want the equivalent effect of doing align="center" on the table tag itself. I...

What is the advantage of serialising an object in a session if the session can hold an object irrespective?

Workflow - User wishes to purchase a file - User goes through credit card process. - Upon successful transaction, redirect user to download file What would be the best way to do this and ensure that : a) a file is only available to those who have paid. Can manage via session value but file...

I have a datetime value and I want to ammend its time and minutes properties based on selected drop down values. These are read only properties however. How can I achieve this? Any help appreciated.