|
I'm developing a web site that has reports which will be billable to the user. So, in this case we need to write to the database user login and logout times. It means session start time and end time.
We are using Oracle 9iAS with Apache 1.3.19 as the http server on Windows 2000. Database is Oracle 8i.
All these days we tried to do it..but could not find a good solution. We tried it with JavaScript but it does not work on some browsers.(Specially on Mozilla 1.0).
Do you know anyway of doing this. If so please let me know it will be great help.
Thank you,
Yamsy
|
|
|
|
|
I'm trying to connect to a MySQl DB using perl DBI.
I'm getting the following error. (running on WinXP, activeperl 5.6.1, MySQL port is 3306)
DBI->connect(database=mysql;host=localhost;port=3306) failed: Can't create IP socket (10106) at C:/Perl/site/lib/DBI.pm line 494
Any clue where to start solving this. I pretty clueless regarding MySQL and DBI.
Thanks!
BW
{insert witty/thought-provoking saying here}
|
|
|
|
|
Hi,
I've created a user Control with contains a DBGrid. I include this user control in a webform. This webform got some fields (textboxes) that I want to validate using, for example the required field validator.
The problem is when I try to insert or modify a row in my dbGrid (which is in the user control...) I cannot save my changes unless all the required field of my webform are filled in.
How can I deactivate the field validator trigger for my user control (or at least when I validate a row in my DBGrid) - knowing the fact that when you validate a change in the dbgrid, you generate a postback.
Many thanks in advance !!!
|
|
|
|
|
Hi, pals!
I want to get detailed information about each object
and each method in Javascript. Can you tell me where
can I find a Javascript reference book?
Cheers,
George
|
|
|
|
|
IMHO the best reference you'll get is from ECMA itself : ECMA javascript.
Then of course you have the Microsoft specific implementation of javascript : JScript. See MSDN.
You also have Netscape's.
And I swallow a small raisin.
|
|
|
|
|
|
Get Danny Goodman's "Javascript Bible" it is very indepth and covers both IE and Netscape flavors of javascript.
Soliant | email
"the result is that VC7 is the only compiler to generate optimized MSIL" - Stanley Lippman
|
|
|
|
|
Hi,
In my htm page I would like to prevent users from opening a new IE window by pressing CTRL+N or from File/New menu.
I tried to test window.opener or window.parent against null or "undefined" but it doesn't seem work.
Any ideeas ?
Thank you in advance.
|
|
|
|
|
Unless you're hosting IE as a control I don't think you can prevent this.
Todd Smith
|
|
|
|
|
At work I have an NT 4 Server/IIS 4 setup with an Access database and some ASP pages that works withour problem. The same pages and the same database are giving me problems at home under 2K Server/IIS 5.
My ASP page looks something like this:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
if not Request("id") = "" then
Dim conn, filePath
filePath = Server.MapPath("database.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
' Debug output code
Response.Write(Request("id") & "<br>")
for i = 0 to conn.properties.count - 1
Response.Write(conn.Properties(i).Name & ": " & conn.Properties(i) & "<br>")
Next
' end of Debug code
conn.Execute "DELETE FROM MyTable WHERE ID = " & Request("id")
conn.Close()
Set conn = Nothing
end if
Response.Redirect("complete.asp")
%>
The result of running this page is as follows:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the maggie home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
/mass/resourcing/delete.asp, line 18
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)
Page:
GET /mass/resourcing/delete.asp
Time:
27 August 2002, 19:29:46
More information:
Microsoft Support
I think it's something to do with write access to the database as I can read from it okay with a different page and AddNew causes similar problems. Any ideas on where to look to sort this out?
The debug output (when the Execute statement is commented out) looks like this:
148
Current Catalog:
Active Sessions: 128
Asynchable Commit: False
Catalog Location: 1
Catalog Term: Database
Column Definition: 1
NULL Concatenation Behavior: 2
Data Source Name: D:\Inetpub\wwwroot\mass\resourcing\masscouk.mdb
Read-Only Data Source: False
DBMS Name: MS Jet
DBMS Version: 04.00.0000
GROUP BY Support: 4
Heterogeneous Table Support: 2
Identifier Case Sensitivity: 8
Maximum Index Size: 255
Maximum Row Size: 4049
Maximum Row Size Includes BLOB: False
Maximum Tables in SELECT: 0
Multiple Storage Objects: False
Multi-Table Update: True
NULL Collation Order: 4
OLE Object Support: 1
ORDER BY Columns in Select List: False
Prepare Abort Behavior: 1
Prepare Commit Behavior: 2
Procedure Term: STORED QUERY
Provider Name: MSJETOLEDB40.DLL
OLE DB Version: 02.10
Provider Version: 04.00.4331
Schema Term: Schema
Schema Usage: 0
SQL Support: 512
Structured Storage: 9
Subquery Support: 63
Isolation Levels: 4096
Isolation Retention: 9
Table Term: Table
User Name: Admin
Pass By Ref Accessors: False
Transaction DDL: 16
Asynchable Abort: False
Data Source Object Threading Model: 1
Output Parameter Availability: 1
Persistent ID Type: 4
Multiple Parameter Sets: True
Rowset Conversions on Command: True
Multiple Results: 0
Provider Friendly Name: Microsoft OLE DB Provider for Jet
Alter Column Support: 36
Open Rowset Support: 2
Cache Authentication: True
Encrypt Password: False
Mask Password: False
Password:
User ID: Admin
Data Source: D:\Inetpub\wwwroot\mass\resourcing\masscouk.mdb
Window Handle: 0
Mode: 13
Prompt: 4
Extended Properties:
Locale Identifier: 1033
Jet OLEDB:System database:
Jet OLEDB:Registry Path:
Jet OLEDB:Database Password:
Jet OLEDB:Engine Type: 5
Jet OLEDB:Database Locking Mode: 0
Jet OLEDB:Global Partial Bulk Ops: 2
Jet OLEDB:Global Bulk Transactions: 1
Jet OLEDB:New Database Password:
Jet OLEDB:Create System Database: False
Jet OLEDB:Encrypt Database: False
Jet OLEDB:Don't Copy Locale on Compact: False
Jet OLEDB:Compact Without Replica Repair: False
Jet OLEDB:SFP: False
Jet OLEDB:Compact Reclaimed Space Amount: 24576
Autocommit Isolation Levels: 4096
Jet OLEDB:ODBC Command Time Out: 0
Jet OLEDB:Max Locks Per File: 0
Jet OLEDB:Implicit Commit Sync: False
Jet OLEDB:Flush Transaction Timeout: 0
Jet OLEDB:Lock Delay: 0
Jet OLEDB:Max Buffer Size: 0
Jet OLEDB:User Commit Sync: True
Jet OLEDB:Lock Retry: 0
Jet OLEDB:Exclusive Async Delay: 0
Jet OLEDB:Shared Async Delay: 0
Jet OLEDB:Page Timeout: 0
Jet OLEDB:Recycle Long-Valued Pages: False
Jet OLEDB:Reset ISAM Stats: True
Jet OLEDB:Connection Control: 2
Jet OLEDB:ODBC Parsing: False
Jet OLEDB:Page Locks to Table Lock: 0
Jet OLEDB:Sandbox Mode: False
Jet OLEDB:Transaction Commit Mode: 0
Derek Lakin.
I wish I was what I thought I was when I wished I was what I am.
Salamander Software Ltd.
|
|
|
|
|
Looks to me like you need to give full security access to the database for the IUSR_* ID.
Paul
|
|
|
|
|
Paul,
Thanks very much. I knew it had to be something fairly simple
To get it working I simply added the IUSR_ account to the Domain Admins group, but surely there's a more secure way?
Derek Lakin.
I wish I was what I thought I was when I wished I was what I am.
Salamander Software Ltd.
|
|
|
|
|
Yeah, that's a pretty dubious way of doing it, you've just given your web page permission to do pretty much anything 
The more secure solution is to have your db in a sub folder of your web page and give IUSR_* full access to that folder (and obviously all it's contents).
Not sure how to do that on NT4 but I'm sure you can. Start by right-clicking on the folder, going into Properties and looking for a Security tab.
Paul
|
|
|
|
|
Excellent. Problem solved. Thanks very much ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Derek Lakin.
I wish I was what I thought I was when I wished I was what I am.
Salamander Software Ltd.
|
|
|
|
|
I want to use raw socket to intercept the ipx packets int the local netware.
I successed in IP, But now I want intercept ipx packets.
Some example codes will be better.
Mail:vcfan@myhexin.com
Can give me some information about it, Thanks a lot!
Everyone is my teacher!
|
|
|
|
|
My Web service is running fine. When I add a web Project to the solution and try to "Add a web reference" for a web service, web reference is not found.
Error Message:The proxy settings on this computer are not configured correctly for web discovery.
Please help!!!!
thanks.
|
|
|
|
|
Hello All,
I've made a simple web service in Visual Studio ASP.Net.
Problem is that I can't view a simple web service with a simple 'HELLO WORLD' WebMethod. When I see the .asmx file in browser instead of show the web service, it shows me the download dialog for download the .asmx file... What's wrong?
Please help urgently!!
Thank you.
|
|
|
|
|
farhanh wrote:
it shows me the download dialog for download the .asmx file... What's wrong?
Have you installed the .NET Framework correctly? If yes then check IIS and make sure ASMX files are one of the accepted extensions. We had some problem with ASP.NET where a virtual folder lost all references to any ASP.NET files, had to manually put them back 
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
ok...i have already those problems and....how did u configured the asmx extensions? what is the exec or dll to execute .asmx files to configure my virtual directory?
If I installed IIS 5.0 first and then .NET why i haven't any extension referred to .asmx files in the IIS??? What's wrong?
Thanx
---
((.)) The Vortex ((.))
|
|
|
|
|
Vortex wrote:
what is the exec or dll to execute .asmx files to configure my virtual directory?
On my system it is: C:\WINNT\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
That is a W2K server box running IIS5.0. Windows XP would be something like C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
Also make sure your Verbs are set to: GET,HEAD,POST,DEBUG. Not "All Verbs."
Though I must stress that there are tons of files (must be 25 in front of me at least) and they all have various settings. So a re-install of ASP.NET is probably best, rather than doing it manually (we could not re-install otherwise it would have interrupted our hosting services, we did it manually but eventually we will do it "properly" in case something was missed.)
Vortex wrote:
If I installed IIS 5.0 first and then .NET why i haven't any extension referred to .asmx files in the IIS??? What's wrong?
I have to admit I honestly do not know. We had the problem but never found the cause of it. We simply had to look at a "working" ASP.NET virtual dir and manually redo the extensions. Real PITA.
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
ok...i've found the way to resolve my problem: to those who can be interested in it i've found the file that register all the ASP.NET extensions in the IIS. Sometimes the .NET installer doesn't do his job well and it not register the ASP.NET extensions in the IIS. When it occurs, we have to use the following file: In .NET Framework directory (by default c:\windows\Microsoft.NET\Framework\<version>\ there is the file that is called : aspnet_regiis.exe
And...that's all. All the extensions (.aspx, .asmx, .asax, .ascx, etc...) have been registered!!!
Enjoy!
|
|
|
|
|
ok...i've found the way to resolve my problem: to those who can be interested in it i've found the file that register all the ASP.NET extensions in the IIS. Sometimes the .NET installer doesn't do his job well and it not register the ASP.NET extensions in the IIS. When it occurs, we have to use the following file: In .NET Framework directory (by default c:\windows\Microsoft.NET\Framework\<version>\ there is the file that is called : aspnet_regiis.exe
And...that's all. All the extensions (.aspx, .asmx, .asax, .ascx, etc...) have been registered!!!
Enjoy!
|
|
|
|
|
Hey Guys,
I am using ASP to load some data from a xml file via xsl. Now i need to sort this data, i know i could use the xsl:sort element but i need a dynamic one, which the user can change. So the user will have the possibilty to sort the data in different ways.
Is there any such function ?
Any suggestions ??
Thanks
Sonu Kapoor
da sonu 
|
|
|
|
|
I wish to create a page which has similar functions to the datagrid but with one main difference. Each record keyfield is displayed from a database which when clicked loads that record in another page.
The main difference is that I since each record will be only 1 item I would like to show more than one record per result row.
[record1] [record2] [record3]
[record4] [record5] [record6]
[record7] [record8] [record9]
Is this possible with datagrid or any of the other data controls (repeater,datalist etc) ?
or
Could I inherit the datagrid and override a method to achieve this effect?
I would prefer to avoid coding it from scratch unless there really is nothing existing that can do the job.
Thanks
It ain't what you know that matters.
Uncle Monkey
|
|
|
|
|
Hello all,
I am using javascript for client side validations and form submission in certain web pages I am developing. I have added code to submit a form, on pressing the "Enter" key. The code works fine in IE and Netscape. But unfortunately the code is not working in Mac IE. Can anyone throw light on this issue ? What are the precautions to be taken when writing client side javascript for Mac IE ? Is there a way to detect IE Mac version and add special code as we do for Netscape ?
Thanks,
Smitha
It's easy to sit there and say you'd like to have more money. And I guess that's what I like about it. It's easy. Just sitting there, rocking back and forth, wanting that money.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
