Problem With Open Database Function
I try to use as much functions as possible. So I have written a function to open a database and retreave the information from a specified field but it don't want to work.
This is the function I use Code:
ADVERTISEMENT
Open Window Function
how to modify a function like this to specify the new window size? I'm able to specify window dimensions easily using window.open in javascript, but am at a loss for how to do it using this vbscript method.The 'strtext' are ASP recordset values. The page the opens in a new window is a map service.
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
function mapLink(strtext)
on error resume next
mapLink = "<a href=""http://planning/ims/tpViewer/?Query=SDE_ADMIN.TP_AREA.TIMEPOIN_1%20%3D%20%27" & strtext & "%27&MapUnits=FEET&ActiveLayer=0&QueryZoom=Yes&Tools=Yes"" target=""_blank"">Map</a>"
End function
</SCRIPT>
Open Window Function (vbscript)
how to modify a function like this to specify the new window size? I'm able to specify window dimensions easily using window.open in javascript, but am at a loss for how to do it using this vbscript method. The 'strtext' are ASP recordset values. The page the opens in a new window is a map service.
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
function mapLink(strtext)
on error resume next
mapLink = "<a href=""http://planning/ims/tpViewer/?Query=SDE_ADMIN.TP_AREA.TIMEPOIN_1%20%3D%20%27" & strtext & "%27&MapUnits=FEET&ActiveLayer=0&QueryZoom=Yes&Tools=Yes"" target=""_blank"">Map</a>"
End function
</SCRIPT>
IE7: Invalid Japanese Characters In Window.open Function
I have a problem with some japanese characters.
When the two Japanese characters ｰ and ｼﾞ are used in the window name
parameter of the window.open function, the expected new browser window does
not open. This needs to be tested on localised Japanese operating system.
The problem only happens on IE7 browsers (on all operating systems). IE6
works ok. Is this a known issue? Any suggestions for a possible solution?
Open A Database
I want to Open a database with asp, I know the syntax to do with VB but how do I make the refference of the DAO in ASP?
View Replies View RelatedOpen Database Value In Word
I'm using ASP to pull info from a database and open it in Word. Everything works fine but I want to specify the paper size to be Legal. Is this possible or am I stuck with Letter size?
View Replies View RelatedSQL Statemet To Open Database
this should be an easy one. I have a script which I use to add a new record to a database. Simple enough. But I have always used this string in opening up a database for just such a purpose:
"SELECT * from images"
Ok, I obviously don't want to select all every time I want to add record, so how would I just get access to that table without opening all of the records? Would it be -
"SELECT images
How Can I Open The Excel Database In ASP?
I have a databse in MS Excel which I would like to use it in ASP? I know in MS Acces the provider parameter is as follow:
Provider=Microsoft.Jet.OLEDB.4.0
What is the equivalent of this provider to open Excel file? Or is there any other way that I should do, inorder to open the Excel files?
Codes To Open An Access Database?
my database is database.mdb
my file path is C:Inetpubwwwrootfypdatabase.mdb
Error Type:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: ''
Besides using this ASP code of opening up my database is here any other way??? I often get the above error due to " This is my present code..
<%
dim objConn, path
set objConn = server.createobject("ADODB.connection")
path = "C:Inetpubwwwrootfypdatabase.mdb"
objConn.open "driver={Microsoft Access Driver (*.mdb)};dbq="& path &";"
%>
Open/read A Text Database
I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt)
DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
Open A Database Connect From One Server To Another
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
View Replies View RelatedOpen Forms In Access Database
how to open or do a connection to open switchboard in the Acccess database? Really Really need help from you who knows the code to open the switchboard in access database using asp. or Is there a way to link switchboard form to the asp page so that when i click on a link , it will open up the switchboard form (lets say the form's name is called "Contact") from the Access Database ?
View Replies View RelatedOpen Database Connection When Users Visits?
Basically everytime I need a page to access a database I will create a connection object, and then at the end of the page I will close the connection object.
Would it be more sensible to create all the connections to the database that a user will need when they first visit the site, and then close these connections once they leave the site. (Using something to do with Start Session and End Session).
Use Asp To Open An Excel File And Upload To The Database
I want to provide a function using asp for the users to search for their excel files in their PCs in IE and then upload to my database.
View Replies View RelatedOpen Word Document Stored In Access Database
anyone know how to open in ASP a word .doc stored in an access database.
Basic Code To Open, Select And Close A MySQL Database
I am looking for the basic code to open, select and close a mySQL database using asp code. I am experienced in php and have a site using php to access this database but this client would like one page using asp.
View Replies View RelatedDatabase Function Input
So far I've been using Sets to read information from the database (Set RS = Server.CreateObject("ADODB.RecordSet") and RS.Open queryString, Conn)
I've got a situation now where I have a function which returns just a single value. I call this function using "SELECT myFunction(parameters)". I can't use a result set to retrieve the function return value, can I? How should I do it?
Search Function W/out A Database?
I would like my ASP-based site to have a search box to bring up a list of relevant pages according to user-defined search criteria.
Q: Do I need to have a d/b like SQL Server 7 at the back end to process and match the search string? Or can I do w/out a d/b somehow and run a search, and somehow still bring up the same results?
If a d/b isn't necc, pls. advise on webpages where I can find such ASP-search codes.... TQ!!
Database Search Function
I have a page that uses the data from the previous pages form to search the data in the database and dispaly any matching results.
On doing so i get this error:
Error Type:
Microsoft VBScript compilation (0x800A03F9)
Expected 'Then'
/IT/searchresults.asp, line 20, column 15
If Request.Form"(Typesearch") = "computer_name" Then
My statement has a then in the statement already.
Nz() Function And JET Database Engine (0x80040E14)
I have beem recommended to use the Nz() function in the ORDER BY part of an
Access2000 stored query.
The query runs correcly from within Access2000
Yet when ran from ASP, it causes an error:
Microsoft JET Database Engine (0x80040E14)
Undefined function 'Nz' in expression.
Where should I define this function?
Database - Recursive Function Calls
..:: The Specs:
MS Access 2000 (host charges extra for SQL/MySQL)
MS Windows Server 2003 (prod) / MS XP SP1 (dev)
..:: The setup:
The database has been setup with two tables;
tblDownloads
tblCatagories
Each "download" consists of a catagory field that corresponds to fldID in
tblCatagories. Each catagory, where the catagory is a parent, has a parent
field of value: 0 and each child, has a field with a value corresponding to
the fldID of it's parent. Code:
Database Lookup In A Javascript Function *before* Displaying The Error
Is it possible to do a database lookup in a javascript function *before* displaying the error alert?
We want to do a database table lookup first and get a BETTER error message based on the text field throwing the error.
Error "Cannot Open Database Requested In Login..."
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails.
/<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then
Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
Below is validate.asp: Code:
Difference Between Private Function And Public Function?
What's the difference between private and public functions in ASP? When should I use either?
How Can I Add Mail Function To That Post Function
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
Function Inside A Function
Can I define a function inside a function. e.g;
function abc()
function xyz()
....some code.....
End Function
End Function
I googled this but can't find any related topic.
Function In The InStr Function
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:
I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.
How To Open .OFT ?
I'm required to write ASP code to open some .OFT (Outlook template) files from within a web app. Does anyone know how to accomplish this ?
View Replies View RelatedHow To Open A Doc In IE?
I devolop a webpage using ASP.NET. i want to redirect my page to certiain links stored in the database. the links can be either URL or Word documents sored in the server. here is my problem. when i redirect my page, if it is a document, it opens the MS.Word appilication.
instead, is there any possibility to open those documents in IE itself with out any confirmation ?
Open PDF
I have an application that generates PDF documents (from an ASP page). In some cases, I need to generate a PDF then provide a link to that PDF from the web page - this I can do fine. In other cases, I want to generate the PDF, but then immediately open the PDF in the browser; in this case, once I have generated the PDF, I am simply using 'Response.Write MyPDFPath' to open the document.
However, for some people this doesn't work, but for some it does. And I can't figure out why results are different. In both cases, the browser address changes to match the URL for the PDF document, but in some cases, all you can see is a blank screen. If you click on the Refresh/Reload button, the PDF displays perfectly - so it's not a show-stopper, but it is a bit of an inconvenience.
Has anyone got any ideas why this may be happening? Is there a better way of opening the PDF? I thought of streaming directly to the client, but that would present the user with an Open/Save/Cancel dialog, which although is more intuitive, it's hardly any easier than clicking on Refresh.
Open PDF
I'm dynamically creating a PDF file using a 3rd-Party component. I've got this much working...
However, once the PDF has been created, I want to open it in the browser. This is where I am struggling...
I can create a page with a link to the PDF, but I dont know how to open the PDF in the browser directly.
Open EXE From ASP
How can I open an .exe File from ASP without getting any message?
View Replies View RelatedOpen Excel In ASP
When I try to open an Excel file from ASP thro' HREF it works fine. But i give the same file in Response.Redirect it says "page cannot be displayed" even when the file exists. Is this related to server configuration?
View Replies View Related