|
'Operation must use an updateable query. '
That's what I get whenever I try and run an INSERT INTO statement from an ASP file. I'm using IIS 4.0 and Access 2000. The weirdest thing is that I've had it working before and I can't remember changing anything! I also get this error when I upload my site to my webspace.
I thought that maybe it means I have to use UPDATE, but that wouldn't create a new record, would it? I really stuck for any ideas, any help would be appreciated.
- X
|
|
|
|
|
The 'Operation must use an updateable query. ' usually means that the IUSR_xxx (anonymous account) doesn't have sufficient rights in the folder where the mdb-file resides.
The user needs write, change and delete rights for locks and changes to the mdb file.
- Morten
|
|
|
|
|
Thanks.
I also found an article in Microsoft's Knowledge Base (Don't have the link on me) that says what you did, just in more words
- X
|
|
|
|
|
How do I get the style properties (like, width, height, etc...) of an ASP.NET page in the code-behind file??
omkamal
|
|
|
|
|
Once you get an answer from your web service, it comes out as XML.
How do I get it into a backend so i can put it in a web viewable interface?
ie. how do i get the answer onto a page or how can i get a stylesheet or do i have to call the stylesheet myself??
The Wudan
Master
|
|
|
|
|
This is not related to your question. Because truly I dont know the answer. But I am curious about your user name. I kinda like that name ever since I saw Crouching Tiger... movie. Are you impressed also??
omkamal
|
|
|
|
|
hi, omkamal
Yes I was impressed with the film I have the DVD.
My fellow developers think Im nutts as I watch the film quite a lot and keep
quoting lines ( in english ) from the film.
I wondered if anyone would recognise it
The Wudan Master
|
|
|
|
|
The only thing that attracts me in the movie is (even though unbelievable) the Martial Arts they play. I read a lot of articles about chinese people who can meditate to an extent which makes their body feel light and were able to fly like a leaf/paper floating in air. There is certain science involved in that too which would be very complicated to explain. But to a novice's eyes they all seem to be fictional. And my friends are novice too that they tease me often when I watch the movie.
I have a DVD of it too. In fact I like all the chinese (good) martial arts movies. Good to know that there is someone(Li Mu Bai) on my page.
omkamal
|
|
|
|
|
Sorted it out now guys......thanx
The Wudan Master
|
|
|
|
|
Can you tell us how. I'd like to do the same sort of thing.
|
|
|
|
|
Hi,
Its easy it does it itself all you have to do is make an app to take the xml and display it:-
QueryDatabaseApp.localhost1.InfoService myService = new QueryDatabaseApp.localhost1.InfoService();
object myObj = myService.getNumberOfTests( SerialNumber.Text );
if( null != myObj )
{
Result.Text = myObj.ToString();
DataGrid1.DataSource = myService.getTestHistory();
DataGrid1.DataBind();
}
else
{
Result.Text = "Serial Number NOT Found!";
}
here is a bit out of the app that uses the web service with a stored proceedure
returning a string and a data set which is put into a grid.
The Wudan Master
|
|
|
|
|
Thanks,
I'll give it a try.
|
|
|
|
|
Is it possible to call a function from a ATL DLL that is on a server that isnt registered? Is there any other ways to do that with ActiveX objects, etc?
I'm assuming "NO!!!!!!!!!" is going to be the answer to this, but I just wanted to make sure, because if files can be uploaded and executed, does that mean you can call functions from a dll? "executing" it?
~Timothy T. Rymer
www.digipen.edu
tim.xpertz.com
|
|
|
|
|
Hi,
I have created a very simple user control that displays one of it's properties within a nicely formated table.
Rather than use a custom property, I'd like to be able to display any HTML between the UserControl tags in the .aspx doc.
ie
Like this:
<uc1:TitledTextBox id="TitledTextBox1" runat="server">Hello mum</uc1:TitledTextBox>
Rather than this:
<uc1:TitledTextBox id="TitledTextBox1" runat="server" contents="Hello Mum"></uc1:TitledTextBox>
Any ideas?
Cheers,
Pete
|
|
|
|
|
|
I'm developing a website where the user will navigate to one of my ASP pages and from there I will navigate to a page in another website. Once I receive the resulting HTML page from that site, I will extract some of the data from it and use it to generate my own page which is what will be seen by the user. This will all happen behind the scenes on the server -- the user will only see the page I send him back with the data from the other website.
What's the easiest way to do this?
Thanks in advance,
Alvaro
Behind a beautiful woman there's usually a guy who just couldn't wait to get rid of her.
|
|
|
|
|
xmlHTTP and advice from your laywer
|
|
|
|
|
Have you tried Microsoft's Internet Transfer Control? You can provide it with a URL (from your user) and it will request the page and return the source HTML to your ASP code as a string. For example:
Set Inet1 = Server.CreateObject ("InetCtls.Inet")
Inet1.Protocol = 4 'HTTP
Inet1.AccessType = 0 'Direct connection to internet
Inet1.RequestTimeout = 60 'in seconds
Inet1.URL = "http://www.codeproject.com"
result = Inet1.OpenURL 'get the sourse for the url.
as the end of this, the string "result" should hold the source for www.codeproject.com, which your ASP can then parse and present to the end user.
Look up "Internet Transfer control" in the MSDN library for more documentation.
|
|
|
|
|
Hi everyone.
I am making a bar chart using System.Drawing. I've figured out how to
do it, but with one problem. The rectangles that are being drawn for
the bars in the chart are always upside down. I don't know why. When I
set the y property of the rectangle, I figured that would be the base
of the rectangle and the height of my rectangle would make it higher
from there. But instead y acts as the top of my rectangle and the rest
is underneath it. So the effect is that my bar charts are upside
down... sagging down as apposed to going up.
Here is the code I am using to create my bar chart rectangle:
//Draw rectangle to make a bar in the chart
objGraphics.DrawRectangle(new Pen(Color.Blue, 2), xInt, yInt,
barWidth, barHeight);
//Create gradient brush
LinearGradientBrush lBrush = new LinearGradientBrush(rect,
Color.Yellow, Color.Red, LinearGradientMode.Vertical);
//Fill rectangle with gradient
objGraphics.FillRectangle(lBrush, rect);
I noticed a few other articles where people said they had problems
with System.Drawing outputting upside down, but there were no answers
that applied to what I am doing, so any help with this is very greatly
appreciated.
Thanks.
|
|
|
|
|
It sounds like the system is treating the upper left corner as coordinate 0,0. Increasing the x dimension moves to the right, increasing y moves down the page. I'm not familiar with System.Drawing, but check to see if there's a property that redefines the coordinate system...
|
|
|
|
|
I'm using Access 2000 on my web site and the whole site is on Russian. The problem is when I'm displaying records from database (russian text) I see only "??????" instead of normal text. On my home computer (Win2000 with Russian installed) i have no problem.
Any ideas why is it so and how to solve it? Or the only way si to ask the provider to install Russian support on one of their servers?
Thanx in advance
Philip Patrick
"Two beer or not two beer?" (Shakesbeer)
Web-site: www.saintopatrick.com
|
|
|
|
|
After sign out from website if i click back button in IE . it is going back , it should not go to previoues page .
can you help me in this regard i am using ASP software .
can you help me plz plz plz
thank you
Siva
|
|
|
|
|
siva_prasad wrote:
After sign out from website if i click back button in IE . it is going back , it should not go to previoues page .
can you help me in this regard i am using ASP software .
Ok, couple of things.
First, put Response.Expires = 0 at the top of any page you want to not be cached.
Second, put some kind of login script at the top of each page you want password protected.
A common example is
Response.Expires = 0
If Session("UID") = "" Then Response.Redirect ("login.asp")
Naturally the Login.asp page will need to put the user id into that Session variable.
This way ASP checks each time a person hits a page to see if they are logged in or not.
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge
Sonork ID: 100.9903 Stormfront
|
|
|
|
|
Can anybody tell is there any limitation to the size of xml file?
thanks
Mazy
Don't Marry a Person You Can Live With...
Marry Someone You Can Not Live Without
|
|
|
|
|
XML itself doesn't set any limits, but your OS or some other piece of software manipulating the file might have a size limit.
|
|
|
|