Search results for query: *

Dear All, I have a table where I keep separately the data and time information in 2 separate columns. My problem come like this query select * from tbltransfer where transferFromDate>='2009-01-30' and transferFromTime>='13:00:00' order by transferFromDate. What I get is all those...

Dear All, I have a system which first receives item as the hq outlet from then I will do a mark up. Eg. say my cost price is 9.9 so I mark up 0.10. So it becomes 10 when it reaches my first outlet. Thereafter the same product can be transfered from one outlet to the other. The problem...

Dear All, I have a system which first receives item as the hq outlet from then I will do a mark up. Eg. say my cost price is 9.9 so I mark up 0.10. So it becomes 10 when it reaches my first outlet. Thereafter the same product can be transfered from one outlet to the other. The problem...

Dear All, I have two databases to be updated at one go to make sure both my databases are committed.One is local database and one is remote database. I am using C# any idea how to make sure both remote and local updated on the same commit.

Dear All, I have very simple javascript which I apply in my asp pages. below is a snippet of my asp code first. here I am building dynamic name for each of record. <input name="qty<%Response.Write Key%>" type="text" class="field-qty" onChange="orderTotal(this.form,'<%Response.Write...

Dear All, I have a query labelled as Query1 and it works perfectly fine and fast even to a remote pc. Unfortunately I have another query to run which now I run based on each value of the receiptID which I have labelled as query2. The problem I cant join it into my query1 is that for each...

Dear All, I got a very simple code to invisible and visible a paragraph. I am using javascript to do it but is just not working. <script type="text/javascript"> function checkForm(this) { //alert("ok"); var myElement = document.getElementById("error_1")...

Dear All, I have set my php 5.2.4 version to work well with apache server. The problem is I cant set mysql to work with php? I have infact set the extension too but mysql is still not working. Can any one help me on this? Thanks.

Dear All, I have several line and text objet in my crystal report. What I want to do is that control this object from my C# code either to show them or not and also the particular line object's measurement like width etc. The problem I am having is how to refer them in my code. Thanks.

Dear All, I am using C# and would like to know how to generate dynamic columns based on my data set? I would like to do some thing how I can freely progrm dynamic column as in web page programming? Thanks.

Dear All, I have called the mysqldump function and managed to backup my file. My code for dumping the file is below. First thing I would like to confirm is my code below is correct one ? The second thing is that how can I ecnrypt and decrypt the file test1.sql which is being...

Dear All, I have a list of product which I run a loop and first I do a insert statement. Following that I am going to update fiels called avarageValue,totalStock and stockValue. So for example first I have a line to insert with productID=123 so once inserted I read what is the current...

Dear All, I am using crystal report with a C# application. So before that I prepare a dataset as the datasource and in it I create 2 datatable one is called dtStockMovementReport and dtStockMovementDetailReport respectively. In both my datatable I got my productID as a column which...

Dear All, I have opened a port and would like to check with telnet. So eg. I telnet 5700 but the screen just goes off I dont know is open or not the port. So how to make the telnet screen stop to show me status? Thank.s

Dear All, I got a list of product where based on a datareader I run a for loop. The based on each of the productID i do a number of select statement from various table around 24 different types of selects. So at some times my code give me an error saying that "unable to connect to any of the...

Dear All, I have a windows application where I have created crystal report .rpt files. So then I wanna set the paper size which is a custom paper size. So currently I am using the server properties method create a new paper size and assign using the design printer setup on the report...

Dear All, I have a windows application where I have created crystal report .rpt files. So then I wanna set the paper size which is a custom paper size. So currently I am using the server properties method create a new paper size and assign using the design printer setup on the report...

Dear All, I have open port 5700 on a pc using by using the advanced settings of local area connection properties and then the windows firewall. The problem when i run netstat -a it doesnt appear in that list. I have no anti virus install in that pc. So what is the cause the port not...

Dear All, Is there a method to encrypt the results from a mysqldump process on windows environment? Thanks.

Dear All, I am using .net connector. I would like to find out can the current versions of .net connector support distributed transaction for multiple database to be committed at one go. Thanks.