Hi,
I have compiled code which appends the data from a csv file to foxpro table. After the append finish it gives an error message saying "Index tag is not found" Table Name is pcmaster.dbf and I have not found any cdx file there. I have used foxpro 10 years ago and have not much knowlege now...
Hi,
Is there a way to extract exchange data using SQL Server?
I have designed an outlook form in Organizatinal library. I want to get the list of all emails using this form with date sent.
Thanks
Shafiq
Hi,
On my aspx page (MyPage.aspx), I am issuing the following commnad
Response.Redirect(ImgURL) ' Where ImgURL is the Absolute Path of the Image
On the image page, if I right click on the image to save it it will try to save it with MyPage.aspx instead of the Image name.
How can I force...
Hi,
If I ran the following query it gives me the month name in Alapabetical order like
SELECT Distinct useMonthName FROM dbo.Summary
Apr
Feb
Jan
Jul
I have a column name useYear and useMonth (1,2,3). I still want to use distinct MonthName but want my results to be sorted by useMonth (1,2,3)...
Hi,
I have filled my dataset from an XML file. I want to add all the records from dataset to a SQL table. Is there a way to do a mass append all the records from dataset to sql table instead of issuing Insert command one by one.
Thanks
Shafiq
Hi,
Is it possible to change the input on prompt to be a password character like * instead of original characters
e.g. When the scipt below will execute it will prompt you to type something, can the input words be masked as **** instead of orginal characters.
<Code>
<SCRIPT...
Hi,
Is it possible to change the input on prompt to be a password character like * instead of original characters
e.g. When the scipt below will execute it will prompt you to type something, can the input words be masked as **** instead of orginal characters.
<Code>
<SCRIPT...
Hi,
I am using the following 4 statements to update the same record based on different conditions. Is it possible to write all 4 update statement into 1 update statement.
Update OrderHeader Set Status = '3' Where OrderID = @OrderID
Update oh
Set TruckNumber = @TruckNumber
Where OrderID =...
Hi,
Will this linked page will execute any javascript code while printing?
<link rel="alternate" media="print" href="PrintPage.aspx">
e.g
PrintPage.aspx
==============
<body onload="setMargins();">
Thanks
Shafiq
Hi,
I have a page which shows the lists of all orders created during the day. If I click print(java script page.print) I will get whatever I see on the page.
But what I want to achive is to print the page having all orders (Page shown on the browser) plus also the order detail page of all the...
Hi,
The following query qives information in a cross tab format. Here You know the total number of columns as Q1, Q2, Q3, Q4.
SELECT Year,
SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1,
SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2,
SUM(CASE Quarter WHEN 3 THEN...
Hi,
My following query returns all data having duplicate data based on LastName + Last 4 Char of Phone
Select LastName , SUBSTR(Trim(Phone),Length(Trim(Phone))-3,4) as PhoneSuffix, Count(*)
from Table1
Group by LastName, SUBSTR(Trim(Phone),Length(Trim(Phone))-3,4)
having count(*) > 1
As each...
Hi,
I am using the following code to display the links as Menu Bar. But when this menu display all the contents below this menu are reshuffled down. Is there a way to display the menu as a layer about the existing data?
Here is my code
<code>
<SPAN onMouseOver="document.all.menu1.style.display...
I am using Master..xp_sendMail to send email to user when a new record is inserted into the sql table. But Sometime multiple copies have been sent for the same email. Is this problem related to SQL Mail or Exchange Server?
Kindly Guide
Thanks
Shafiq
Hi,
I have a drop down list using Select and option tag in HTML.
When some one change the selection in the drop down list, I want give them a warning the selection has been changed, Are you Sure, If they select Ok the change should happen but it they select cancel the change should not happend...
I am using the following code to copy the link information to the clipboard
http://www.htmlgoodies.com/beyond/javascript/article.php/3458851
Suppose my clipboard contains the following
<a href="http://MyServer/Default.aspx?page=1">My Link</a>
When I want to paste this clipboard in OutLook I...
Hi,
Is it possible to find out which page is the iframe serving at any point?
e.g
<iframe id="ContentFrame" name="ContentFrame" src="home.aspx">
At the start home.aspx is serving but this page has links to other pages so at any given time how can we find out which page he is serving...
Hi,
I want to include a file from a different web site.
e.g
http://MyWebSite1/Dir1/page.asp contains page.asp
in my 2nd site, I want to include page.asp , How can I do that?
Thanks
Shafiq
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.