|
Hi Joan!
It is not vey complicated to call / open a database file via asp or php. First you have to have a database file under a specific directory on the server. Make sure it is password protected. Then it is easy follow my steps below.
1. You have to define the path and connection string for the file. Therefore, make sure that you include the likely statements below in your inc. file.
DPath = Server.MapPath( "_database\FILE.MDB" )
ConnStr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Dpath & ";Jet OLEDB:Database Password=12345;"
2. We have to initiate a connection to database when it becomes essential for you to open the file and perform several tasks
Set ObjectConnection=Server.CreateObject ("ADODB.Connection")
ObjectConnection.Open ConnStr
3. Define a specific SQL string such as
SQLSTR = "SELECT * FROM stocks WHERE GoodsIndex = 10"
4. We have to initiate recordset. Therefore use the following statements
Set ObjectRecord = Server.CreateObject ("ADODB.Recordset")
ObjectRecord.CursorLocation = adUseServer
ObjectRecord.CursorType = adOpenkeyset
ObjectRecord.LockType = adLockOptimistic
ObjectRecord.Open SQLSTR, ObjectConnection,,, adCmdText
notice: adCmdText is used to process a SQL string command if you want to open a table directly you can also use admCmdTable statement.
5. okay lets reach the data with ADO
If ObjectRecord.RecordCount > 0 Then
SelectedGood = ObjectRecord("GoodsName")
End If
6. When you done close the connection
SET ObjectRecord = NOTHING
ObjectConnection.Close
DONE!
I hope it works for you!
|
|
|
|
|
hi! there is a web page calles mt.aspx. there is input button on it. when i click on this button a new popup window open.there is another button on it that is closed popup window. now i refresh first window & on clickin close button popup window doesn't close. actually on refreshing parent window reference of child window lost. is there any way to close child popup window from parent window after refreshing parent window?
|
|
|
|
|
No, there isn't. As you lose the reference to the child window by reloading the parent window, you can not reach the child window any more.
---
b { font-weight: normal; }
|
|
|
|
|
is it not possible to save reference of child window in the cokies or in hidden field? and after that i type cast the value of hidden field in the objec?
|
|
|
|
|
you need reference to the child window, not a value which is stored somewhere else and retrieved.
|
|
|
|
|
No. The values you save is a cookie or send in a form are only text values, and you can not store an object reference as text.
---
b { font-weight: normal; }
|
|
|
|
|
Hello firends
when I recieve new email from AJAX,Without any refresh it shows me I recieve new email and number of add one to number of email in inbox.
I want to know how gmail do that?
Is it by AJAX?
When we use AJAX,User does something ,And after user did an action on interface ,then interface will change,But in this case it shows me without any refresh or without any action on interface,Please know me if you know any tutorial about this case.Do you AJAX code for that?
I heard that Gmail uses a hidden iframe for its Ajax calls. Regardless, you can easily do auto-updating without any user interaction by setting a repeating callback (with setTimeout or similar) which polls the server for updates every X seconds.
May someone give me code for these idea?(use settimeout and use Iframe)
Thanks in advance
|
|
|
|
|
Yes that is AJAX. Just google for some tutorials. There are plenty.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hello my firend
How?
How Gmail use AJAX to do something like that,I know something about AJAX,But I want to know How GMAIL use that?
I saw something about google suggestion ,But I want to know about Gmail.Do you know any tutorial that shows how gmail does that?
GOOD LUCK!
-- modified at 0:44 Monday 18th September, 2006
|
|
|
|
|
Nope (that dosen't mean there is none)
But if you will study AJAX enough you will figure that out by yourself.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hello
Could you show me the AJAX code that Gmail use?
Thanks,
GOOD LUCK!
|
|
|
|
|
abalfazl wrote: Could you show me the AJAX code that Gmail use?
dude!! how can anybody give you some code which gmail is using. You can ask for some ajax sample code but not the gmail code isn't it? 
Best Regards,
Apurva Kaushal
|
|
|
|
|
I've spent tonight trying to get jscookmenu to work in an ASP.NET project. Even in a html page, it works sometimes, but in an aspx, I have the following in my header:
<SCRIPT type="text/javascript" src="./menu-js/jscookmenu.js"></SCRIPT>
<LINK rel="stylesheet" href="./menu-js/ThemeOffice2003/theme.css" type="text/css">
<SCRIPT type="text/javascript" src="./menu-js/ThemeOffice2003/theme.js"></SCRIPT>
These files exist.
Then in the body I have this:
<DIV ID=MenuID11></DIV>
<SCRIPT type="text/javascript">
<!--
cmDraw('MenuID11', wbMenu11, 'hbr', cmThemeOffice2003, 'ThemeOffice2003');
-->
</SCRIPT>
The point is, theme.js defines cmThemeOffice2003, and cmDraw them passes this to the menu code. Instead I get an error that cmThemeOffice2003 is undefined. But it ISN'T. Does anyone have any suggestions what IE is really trying to tell me here ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Are you using a correct path to the files? Put some alerts in the files and in the page, so that you see if the files are actually included, and if they are executed in the order that you expect.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks - the path is correct, if I put the code into an ASPX either directly or through REgisterClientScriptBlock calls, it works fine. When I try to move the menu into my master page, or one of it's clients, the includes just don't seem to happen. Do you know of any issues with jscript includes in master pages ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
If you put the link tag or script tag in the master page, you have to specify the location of the file relative to the master page. If the page that uses the master page is in a different folder, the address will be corrected to still point to the correct file.
For an example if have the master page /Profile/Master.master that has the tag:
<script type="text/javascript" src="scripts/test.js"></script>
and use the master page in the page /Content/Info.aspx, the tag will end up as:
<script type="text/javascript" src="../Profile/scripts/test.js"></script>
---
b { font-weight: normal; }
|
|
|
|
|
im working in asp.net for quite a while. but still naive in asp.
i ve some asp web site pages, which i need to run and review.
i created a folder (say myapp) and created an application using IIS and put all the asp pages in that Folder.
when i run http://localhost/myapp/index.asp it throws error
page cannot be found "subfolder/header.asp"
"subfolder" is a folder inside "myapp" folder
i understand ( ) there is a code within the index.asp
which i learned as a server side includes.
how can i figure out whether my server (IIS) supports SSI. i ve .net 1.1 installed in my machine and can run asp.net applications well.
what i ve to do to include the subfolders inside "myapp" to the application to run it properly.
Thanks for ur attention,
Harsha
-- modified at 3:56 Saturday 16th September, 2006
|
|
|
|
|
harshActsw wrote: how can i figure out whether my server (IIS) supports SSI.
It does.
harshActsw wrote: what i ve to do to include the subfolders inside "myapp" to the application to run it properly.
You have to write a proper path to the file that you want to include. As you are using a virtual path, it will start from the root of the web application. If you have created a web application for the folder, the root will be located at c:\inetpub\wwwroot\myapp. If you just created a folder inside the default web application, the root will be located at c:\inetpub\wwwroot. You have to write the path to the file relative to the root.
You can also use a relative path, by using the file keyword instead of virtual. Then you specify the path from the location of the page that is including the file.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks a lot,It works fine.
|
|
|
|
|
Hi,
Could someone explain to me what a closure is and where are they used? I prefer an explaination in javascript.
thanks
|
|
|
|
|
|
Have you ever tried Google Notebook? After installing the software, it will add a button at the bottom-right corner of IE. Dose anybody know how to implement that ? Any reply is appreciated.
Thanks
R.Y.J
|
|
|
|
|
Please don't cross post.
---
b { font-weight: normal; }
|
|
|
|
|
Hi everybody
I'm trying to create a simple IM (based on IP), but I have far more basic problem.
I'm trying to ping my girlfriend's computer, but for some unknown reason I cannot see her ip (I'm getting "request time out").
my computer is connected to the net directly, while her computer is connected through a router to the net.
lets say that my internet IP is: 44.0.0.1(according to whatismyip.com)
my girlfriend's internet IP is: 77.0.0.1 (according to whatismyip.com)
my girlfriend's router IP (in her local network) is: 192.168.0.1
my girlfriend's computer IP (int her local network) is: 192.168.0.2
now, from my computer and her's I can ping to random sites like www.yahoo.com etc., but when I'm pinging from my computer to hers (from 44.0.0.1 to 77.0.0.1) I get request time out.
I REALLY don't understand why is that, and how to solve it (I will need it if I want to connect to her computer directly).
Besides, if I ever get this problem solved  , I still need to direct myself into her comptuer in her local network (tell the router that I want to address 192.168.0.2 which is her computer).
Thanks alot for any kind of help! I am extremely stuck!
|
|
|
|
|
Green Fuze wrote: when I'm pinging from my computer to hers (from 44.0.0.1 to 77.0.0.1) I get request time out.
The router may be set up to not accept ping, or a software firewall on the computer may be.
Besides, if I ever get this problem solved , I still need to direct myself into her comptuer in her local network (tell the router that I want to address 192.168.0.2 which is her computer).
No, you don't. You use the ip address of the router when you communicate with her computer. The router translates back and forth between the external ip address and the internal ip address.
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
