I need a file browser window to open, and the user to pick a file from the browser, and have the file path and file name returned as a string. I have this code:
Function PickFolder(strStartDir As Variant) As String
Dim SA As Object, F As Object
Set SA =...
I have a web page that when it loads a confirm box opens likes this:
var agree = confirm("This is the confirm text.");
if (agree)
{
return true;
} else {
window.location.href = "http://www.google.com";
}
The problem is, that on one person's computer, when the page loads the...
I have a web application in ASP that updates a table in a SQL Server database. We have a windows network here. Is there any connection string for ADO using OLEDB that will persist the windows login information through to SQL Server?
This does not seem to work, even though the user is...
I have an html hyperlink like this:
<a href="#" onclick="orderBy('ID');">ID</a>
right now the function is just this:
function orderBy(theField) {
}
When I click the hyperlink in IE I get this error:
Object doesn't support this property or method.
on the line with the hyperlink.
Why...
I want to open a tif image file using Windows Picture and Fax Viewer over the web via a hyperlink. However, I get prompted to save or open the file. Can this be done using vbscript and wscript.shell?
Dim objWShell
Set objWShell = CreateObject("WScript.Shell")...
I have an asp page that sends an xml http request to another asp page which sends back some data. In the page sending the request, there is a session variable. The page receiveing the request uses that session variable. However, the page receiving the request is somehow not "getting" the...
I have a link on a page that points to a pdf document. I'm using target="_blank" to open the pdf in a new browser window. But when you click the link, a new browser window opens but the pdf does not load. And whe you refresh the page it still does not load.
<a href="http://myserver/the pdf...
I want to create triggers on all the tables in a database that will update a date field in the sysobjects table with the current date anytime a record in any of the tables is updated.
My question is: is it recommended to alter the sysobjects table in any way?
Information is not Knowledge...
I have 2 computers at home. Both are connected to the internet via a wired router. The internet works fine on both. I want to network these computers together to share files and printer.
I have gone through the windows network connection wizard on both computers. In windows explorer the...
I have an asp page with an html form in it. When I execute this code:
test = request.form("field")
response.write(test)
it writes out the value of the form field "field". However, the strange thing is that there is no form field called "field" !!
Is this possible? or am I crazy?
thanks
ft...
I need to write a trigger that will do the following:
Delete a record and copy it into another table (exact same structure), when the "Status" field of that record is updated to "A".
I'm new to triggers and would be grateful for an example, if this is even possible.
thanks
ft
Information is...
I have this server side code that accepts and xml stream from another page:
Set objXmlHttp = Server.CreateObject("Msxml2.ServerXMLHTTP")
objXmlHttp.open "GET", url,False
objXmlHttp.send
strHTML = objXmlHttp.responseText
set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")
set...
I have a vb script that I want to run on a server everyday at a specific time. Is this possible with vbscript? if so, how would one go about doing this?
thanks
ft
Information is not Knowledge, Knowledge is not Wisdom, Wisdom is not Truth, Truth is not Beauty, Beauty is not Love, Love is not...
I have this trigger:
CREATE TRIGGER updateDateEdit ON dbo.Tester
FOR UPDATE
AS
IF @@ROWCOUNT =0
RETURN
UPDATE Tester SET DATE_UPD = DateAdd(Day, DateDiff(Day, 0, GetDate()), 0)
FROM dbo.Tester Tester
INNER JOIN inserted ON Tester.ID = inserted.ID
This will add today's date in the...
I am very new to Delphi, but I am really liking it. I have an asp page that writes some text into the response. For example:
<%
response.write("Hello")
%>
I have a delphi application with a form and a TEdit box on the form. Is there any way I can set the text in the TEdit box to be the...
I just started working with Turbo Delphi today. I have created a form with an TADOConnection, TADODataSet, TDataSource, and TDBGrid. I now want to test the form to see if it works. How do I "run" the form? The run button is greyed out.
thanks
ft
Information is not Knowledge, Knowledge is...
I have a date field that I want to default to the date when a record is added. But getDate() inputs the date and time. Is there a way to set the default value of the field to just the date component i.e. 10/13/06 ??
thanks
Information is not Knowledge, Knowledge is not Wisdom, Wisdom is not...
I'm trying to delete a table from SQL Server and when I execute the SQL through Query browser:
drop table dbo.tablename
it says it is executing query batch, but it just sits there. I let it go for 5 min and it did not delete the table. Why would this happen?
Information is not...
I want to update a date field every time a record is updated, but only for the record that was updated.
I have this:
CREATE TRIGGER updateDateEdit ON [dbo].[Tester]
FOR UPDATE
AS
UPDATE dbo.Tester SET DATE_UPD = GETDATE()
but it sets the date for all records, not just the one that was...
I have a <select> drop down menu that I want to set the selected value of using javascript. Can this be done?
<select name="sel" id="sel">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
And I need to do this...
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.