|
In my Perl script , Im using Win32::OLE to access and read an Excel file. The annoying thing is that every time an Excel file is accessed, a shortcut for it is automatically created at the root of my C: drive. If I access 3 different Excel files, there will be 3 different shortcuts created. These are not temporary files -- they remain there permanently (until I manually delete them). What is doing this??? Is there some Excel macro that's doing this? Or does it have to do with some configuration setting in IIS? I've been trying to search the internet for this topic but cant find anything. Please help if you can. Thanks.
|
|
|
|
|
Hello. My problem is that I wrote a session handling-script from a book I bought, but the code they have connects to a MS Access database. I can't use Access databases at my webhotel so I tried to rewrite it to connect to MySQL instead. It doesn't work for me.
The MS Access version connects via a file called Global.asa and via ODBC. The Global.asa file looks like this:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
SUB Application_OnStart
Application.Lock
Application("Conn") = "driver={SQL Server};SERVER=localhost;UID=login;PWD=password;Database=database"
Application.UnLock
END SUB
</SCRIPT>
(The SQL Server code I've added myself, it's supposed to be the same type of connectioncode there but for Access)
And this is how my connection strings in the documents looks like:
Login:
<%
un = Request.Querystring("un")
pw = Request.Querystring("pw")
If (Len(un) > 0) And (Len(pw) > 0) Then
Set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection = Application("Conn")
ssql = "SELECT id FROM cmy_se WHERE un = '" & un & "'"
ssql = ssql & " AND pw = '" & pw & "'"
Cmd.CommandText = ssql
Cmd.CommandType = adCmdText
SET Rs = Cmd.Execute
if NOT Rs.EOF Then
Session("userid") = Rs("id")
%>
Newmember:
<%
email = Request.Form("email")
un = Request.Form("un")
pw = Request.Form("pw")
If (Len(email) > 0) AND (Len(un) > 0) AND (Len(pw) > 0) Then
Set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection = Application("Conn")
ssql = "SELECT * FROM cmy_se WHERE un = '" & un & "'"
ssql = ssql & " AND pw = '" & pw & "'"
Cmd.CommandText = ssql
Cmd.CommandType = adCmdText
Set Rs = Cmd.Execute
If Rs.EOF Then
SQLStmt = "INSERT INTO cmy_se"
SQLStmt = SQLStmt & "(email,un,pw)"
SQLStmt = SQLStmt & "VALUES(?,?,?)"
Cmd.CommandText = SQLStmt
Cmd.CommandType = adCmdText
Set prm = Cmd.CreateParameter (,adVarChar,,Len(email),email)
Cmd.Parameters.Append prm
Set prm = Cmd.CreateParameter (,adVarChar,,Len(un),un)
Cmd.Parameters.Append prm
Set prm = Cmd.CreateParameter (,adVarChar,,Len(pw),pw)
Cmd.Parameters.Append prm
Cmd.Execute
ssql = "SELECT id FROM cmy_se WHERE un = '" & un & "'"
ssql = ssql & " AND pw = '" & pw & "'"
Cmd.CommandText = ssql
Cmd.CommandType = adCmdText
Set Rs = Cmd.Execute
If Not Rs.EOF Then
Session("userid") = Rs("id")
%>
What changes must I make to get it to work with my MySQL database?
Might I add I can't use ODBC or DSN, I have to use a direct connection.
Thank you.
Yeah..
|
|
|
|
|
Some people on the ASP.NET forums have been talking this one up but I don't think it's free http://crlab.com/mysqlnet/[^] there are a couple of open source things on sourceforge but I don't think they are complete but you could give them a try. The only other way is using ODBC.
|
|
|
|
|
As far as I can see, you're not using a Connection object, but the ConnectionString property of that object!
Beside that you'll probably want the MyOLEDB provider.
To get it to work:
objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "driver={SQL Server};SERVER=localhost;UID=loginWD=password;Database=database"
A word of caution: don't open the database connection in your global.asa. This will 'kill' the webserver if you have more than 1 user. IOW: open the connection just before querying and close it as soon as possible thereafter.
|
|
|
|
|
Hi,
is it possible to create web page layout like this:
______________________
| | |
| 100px | Width-100px |
|<----->|<------------>|
| | |
| | |
|_______|______________|
using DIVs and styles ?
I know how to divide page to two parts using width in percents but how to do this with pixels ?
Thanks!
i'm only pointer to myself
|
|
|
|
|
Do you mean 100% in the second block, not 100px?
Paul Watson
Bluegrass
Cape Town, South Africa
Crikey! ain't life grand?
|
|
|
|
|
I mean something like this (but without table):
<table width="100%">
<tr>
<td width="100px"> Left... </td>
<td> Right... </td>
</tr>
</table>
i'm only pointer to myself
|
|
|
|
|
Ok, so a fixed width left column and the a variable width content column.
Sure, use this:
<div id="navigation">
<ul>
<li><a title="Page link" href="">Page 1</a></li>
<li><a title="Page link" href="">Page 2</a></li>
<li><a title="Page link" href="">Page 3</a></li>
<li><a title="Page link" href="">Page 4</a></li>
<li><a title="Page link" href="">Page 5</a></li>
<li><a title="Page link" href="">Page 6</a></li>
</ul>
</div>
<div id="content">
<h1>Page Title</h1>
<p>Content content content content content content content content content content content content content content content content content.</p>
<p>Content content content content content content content content content content content content content content content content content.</p>
<p>Content content content content content content content content content content content content content content content content content.</p>
<p>Content content content content content content content content content content content content content content content content content.</p>
</div>
and then CSS:
div#navigation
{
width: 100px;
float: left;
border: solid 1px #000000;
height: 100%;
}
div#content
{
padding-left: 120px;
border: solid 1px #000000;
}
So the idea is to have a DIV on the left with float:left set and a fixed width. Then the DIV on the right expands to fill the space. The padding-left: 120px; keeps it off the left DIV.
Paul Watson
Bluegrass
Cape Town, South Africa
Crikey! ain't life grand?
|
|
|
|
|
Thank you !
i'm only pointer to myself
|
|
|
|
|
<style type="text/css"><!--
body {
margin: 0 0 0 0;
}
div.nav {
position: absolute;
width: 100px;
background-color: #dfdfdf;
height: 100%;
}
div.content {
position: relative;
left: 100px;
right: 0;
background-color: #7f7f7f;
height: 100%;
}
--></style>
<div class="nav">
Asparagus
</div>
<div class="content">
Content
</div>
- Mike
|
|
|
|
|
That is a pretty cool way of doing it as well Mike. I really need to remember absolute positioning more.
Paul Watson
Bluegrass
Cape Town, South Africa
Crikey! ain't life grand?
|
|
|
|
|
I have to convert Rich Text (rtf) code to HTML code so they can display on the internet explore...
In RTF code, there is \tab which is same as pressing Tab key to move/ jump to next 10 space from original in notepad\wordpad\or MSWord...
I mean... ( considering dot (.) as a space )
abcd.........efgh.........ijklm.......... nopqrst .......... uvwxyz
ok...........this.........is a........... three row......... and
five.........columns......but............ not using......... table
I dont' no I can't use < table >
Is there anyway that display tab or spaces in the browser without using table tag??
hello........ how .......... are you?
hello........ I'm .......... fine
hello........ you .......... are nice
thank you
|
|
|
|
|
Are you using VS.NET
Are you using VB or C#
Need more info.
Will
|
|
|
|
|
i'm sorry to reply you that late..
i'm using VB.Net and vbTab is not recognized by web browser
|
|
|
|
|
I have been searching for information on wether it is possible
to add a shortcut to the favourites in the IE browser that links
to an application ( a .exe program) on the local computer as
opposed to a url on the web.
Can anyone give me information on this, is it possible?
many thanks
|
|
|
|
|
I'm trying to call asp function just simply by clicking a button
But could i do this method? or how could i pass the function and values
Thanks for the responce
> It should be something like this:
|
|
|
|
|
you can't call server side script from VBScript like this
what do you want to make ?
instead you can make a frame and write a script like this :
Frame1.Navigate "page1.asp?var1=X"
or use databinding if you use IE.
|
|
|
|
|
Hello,
I need some help with creating a word maker in Java. the user should be able to enter a list of words at least nine of them (3 x 3) grid will be formed and should be abl to grow.
an import button should be available to import a list of words from a text file into a world list which will be compared with the list of words in the grid.
a make grid button should be availabe to allow the user create the grid after the letters have been entered.
a make word button should also be available for the user to click and search for the words in the grid. the words can be found diagonally, horizontally and vertically.
if i could get some help on how to do this i'll be very greatful thanx.
Tony
|
|
|
|
|
|
Is there a possibility in Client Side script to find out whether an URL was already visited or not?
"Der Geist des Kriegers ist erwacht / Ich hab die Macht" StS
sighist | Agile Programming | doxygen
|
|
|
|
|
you can access a history object with window.history
history object properties:
current<br />
length<br />
next<br />
previous
Methods:
back()<br />
forward()<br />
go()<br />
toString()
I haven't used it myself, but I think it's only for the active browser window.
Hope that helps.
let the whole world look in
who cares who sees anything
BW
|
|
|
|
|
I'm trying to call multiple asp page just simply by clicking a button
But could i do this method? or how could i pass the value from this page to another asp page.
Thanks for the responce ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
> It should be something like this:
<SCRIPT LANGUAGE='VBSCRIPT'>
<!--
function btnClick_onClick
document.form.action = "myform.asp?ID=" & document.form.txtfield.value
document.form.submit
End Function
-->
</SCRIPT>
|
|
|
|
|
is there a way to load an html document into another one using java script?
|
|
|
|
|
What is it that you want to do...
If you give some more details I think that I can help you...
theJazzyBrain
Wise is he who asks good questions, not he who gives good answers
|
|
|
|
|
Here is my problem from another forum I tried:
I tried IFRAME and it worked with a bit of fiddling, but I don't like the extra scroll bars it adds, and I think that it only works in IE...... though not sure.
I read in another post about server side includes, but I don't know any php, and wasn't sure if I should do it that way. I managed to load the page using Java Script like this
#menu
{
position:relative;
background :#66CCCC;
float:left;
width:20%;
height:100%;
}
#content
{
position:relative;
float:left;
height:100%;
width:80%;
}
</style>
</head>
<body>
<div id="menu"> menu goes here</div>
<div id="content">
<script type="text/javascript">parent.location.href='../html/ch1/notes/Unit1a.htm';
</script> </div>
</body>
</html>
(I put another post about thisJ) However I have the problem with the file being over writing the menu, I tried changing to relative positioning with little luck.
What I want to do is have two columns side by side, one menu and on the right a dynamically loaded html page. I am writing some javascript to automatically generate a menu of links from the heading tags in my html page, that is the eventual aim. So that whatever page is loaded a set of hyperlinks will be put on the left. The idea is to save me time in making up a menu though it hasn't worked so far  .
BTW, is there a way to specify a fixed column width for one column, and have another expand to fill the rest of the screen cf frames??
Cheers
Andy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
