The way I include my connection string into pages is by using Application level variables.
conn.Open(Application("ConnStr"),Application("Uname"),Application("Pwd"))
You can also use an include file in which you specify uname and pwd. You shouldn't hardcode it even...
I agree.
Use paging. Imagine your users have to access the table over the dial-up for some reason...
Also, some browsers have crashed on me in the past (on Win98) when too much information is passed, so it's not a good idea to do that.
Here's a great resourse on paging (which I use on almost...
You mean you want to dynamically include an ASP page into HTML page, like you do with include files?
I am pretty sure you can't do that...
You can use frames to do it, though.
Or, why not just rename .htm file to .asp? Is there any specific reason you don't want to do it?
Then, in page1.asp...
Here ya go:
NOTE1: It's in Javascript, but should give you some ideas even if you use VBScript
NOTE2: I hope my sourcecode is not going to get interpreted as HTML...
<%@ Language=JavaScript %>
<!--#include virtual="/include/adojavas.inc"-->
<%
// if username is already taken...
I would suggest physically removing the backspace key from the keyboard - that should do it :-)
If you're using IE, you can try to find a browser that doesn't use backspace as BACK button.
But I do know how frustrating it can be when you use backspace to modify content of input field, then...
I don't know what happend in the past...
Strange things happen with these computers sometimes :-)
No, it can't register itself, so maybe this was related to a problem inside a COM component (like a memory leak, or if after a certain number of times it is created it stops working), but that's...
You mean you want to store the actual file in the database?
If so, then
1) I am not sure you can do it in Access
2) It is not a very good idea - the database is going to be pretty hard to manage...
When I upload files, I only record their names in the DB, and then store them as actual files...
Hmm...
Never heard of an object that would be produced by Server.CreateObject("Program.WebUtility")... Google search doesn't produce anything as well.
So chances are it is an internally developed COM component that your company is using...
If I am right, then I have no idea how to...
Can you post the part of code that creates an object?
It should be something like Server.CreateObject("BLAH_BLAH")
Maybe the dll you are referring to is not properly registered...
Is it a built-in object you are trying to create or a custom component your company uses? <Dmitriy>...
You are right.
Stored procedure is going to be the fastest since it is pre-compiled imside SQL server.
And it is pretty simple to use.
Instead of
SET RsN = Conn.Execute(Sql)
you just do
SET RsN = Command.Execute()
(Of course you need to create stored procedure and command with appended...
Hey,
I may be doing this doen the road too, so I thought about different ways of doing it.
I think it can be done using PDF files with predefined layout. THen you can insert text into the PDF from the database or an HTML form.
You can use either ActivePDF component (haven't tried it yet) or...
Well,
Why can't you just do this:
Application("arrMonthNumbers")=("01","02","03")
Application("arrMonthNames")=("January","February","March")
I am pretty sure you can't store two-dimensional arrays in Application...
Looks like you need a JOIN statement:
SQL Sample:
SELECT o.orderID, o.orderDate, p.manufacturer
FROM Orders o
INNER JOIN Products
ON o.ProductID = p.ProductID
WHERE orderID = <order_ID>
I hope that is in the general vicinity of what you were looking for :-)
<Dmitriy>
dbrom@crosswinds.net
<META HTTP-EQUIV="Refresh" CONTENT="5;URL=http://www.some.org/some.html">
There's the META tag Dynapen was talking about.
Use this or Javascript I provided above
Good luck <Dmitriy>
dbrom@crosswinds.net
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.