I'm running a script with Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
it works fine when i view it from my computer, but when someone views it from the outside that get an error msg inthe script saying a page doesn't exist. is this a permission problem? how do I fix it?
How do I insert a record in a database if it doens't exist? For example, I need to see if the answer for a question exists and then if it doens't I need to insert a blank record.
Something like:
if questionID = 20 doesn't exist, insert blank record for questionID = 20
if questionID = 21 exist do nothing
table is Answers(QuestionID, Answer)
I need to do this in order to be able to do an update. Some questions were not in the previous form.
I have this sql statement which picks up the corresponding rating from the Rating table and matches it up to the artist from the Song table:
SELECT rating, song.artist, song.delid, song.date, song.id, rating.id, song FROM rating INNER JOIN song ON rating.artist = song.artist
I want to make another page though that'll only show the songs which have no rating.
Just when I thought I was done , I try going to the "myfolder.asp" page and I get an error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.55-nt]Table 'streetguide.max' doesn't exist
/streetguide03/members/myfolder.asp, line 73
Line 73 is in red.
This is because the user didn't have a folder created, because they didn't save anything to their folder. On another page I have code that creates a table with the same name as the UserName, only if they decide to save something in their folder. Code:
I ran IISLockdown for another problem and it trashed IIS. ASP pages wouldn't
run at all. So I Googled it forever to no avail. So I unsintalled IIS and
resintalled it. Now the status is that ASP pages ask me to login and then
they run. I assigned the maximum permissions to the IUSR_xxx account as well
as gave it read permissions to the folders it is using. Code:
I allow my users to upload a picture from their machine to my website on the server. I know the exact name and the path of the uploaded picture in my server, is something like:
D:hostingmysitedbgraphicspicturename.gif
Then, I would like to insert this picture into my home page. How can I do that without manually download the picture from server to my machine? How can I insert a picture that exist in my server into my page?
As long as I would like to show data from +/- 5 different records in a table, I do not have any problem and my page is running OK. As soon as I would like to show +/- 40 different records in my table the page doesn't open. I'll attach the code and maybe someone can tell me why it works with less records but not with all. Code:
View Replies View RelatedI'm make a site that will contain an include statement that updates and gets data from the DB, but the text after the include doesn't display. When I don't have the include statement, the page displays perfectly.
Here's my statement:
<!-- #include file ="getData.asp" -->
Please let me know why it's not letting me display anything after my include statement, and what I can do to fix that.
If an ASP page works locally on your system but doesn't work remotely on the web hosts server and your only alteration to the page before uploading is your connection string to make it point in the right direction on their server then surely the fault has to be the path to the servers database doesn't it?
Or is there another possibility why the page would show up an error page.
I have a page with 2 frames. The first one has a link that loads a page in the second frame. This page has a button on it. When the button is hit, the page does some processing and loads another page in the same frame (the second).
I use ASP and response.redirect or javascript in the onclick event of the button to do the redirection. When I refresh the page by clicking the button on the browser (IE), the second frame becomes empty. Please note that the src attribute of the frame is not set.
If I set the src attribute of the second frame to some asp page and then navigate to another page inside the same frame, when I refresh the page, the initial asp page is loaded in the frame regardless of the asp page currently loaded into the frame.
It seems that when you refresh the page, the frames are reinitialized no matter what pages are currently loaded in the frames.
I solved the problem by redirecting to the main page in the top frame, passing some parameters and resetting the src of the frame to the desired asp page. Thus, when the page is refreshed, all the frames are properly refreshed too.
If I need to check if a certain value does exist in a field, and return either "yes" or "not" which query would be the most effestive?
View Replies View RelatedHow do I find out if an url exists? Whar I want is a function like this:
If UrlExists("http://www.test.com/test.html") Then
Response.Write("Yeah!!")
Else
Response.Write("No file :-(")
End If
Can anyone help?
IS there a way I can do an If exist to determin if a graphic is displayed?
something like this;
<p align="center">
if file exist "fileone.jpg"
<img border="0" src="fileone.jpg">
if File exist "filetwo.jpg"
<img border="0" src="fileone.jpg">
</p>
What I am trying to do is post JPGs from a folder structure, the files may
or maynot be there, but I don't want to have the blank picture reference to
be displayed as if I where to just hard code the graphics in the Html!
Everything was working fine on my website until last night we started getting the following error message while viewing to see the pages. Website is running on asp and sql server.
Microsoft OLE DB Provider for ODBC Driverserror '80004005'[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
reports/penaltyrankingreport_web.asp, line 19
I checked the line in my code and its the line when the code is opening the recordset...
"objconn.open"
i already referred the following article on microsoft but not exactly sure in which direction to troubleshoot because i didn't make any changes to code, servername, database properties.
http://support.microsoft.com/default.aspx/kb/328306
internet information server does not work. when i try to open any website
from iis it gives error :"Class does not exist"
Moved from Windows 2000 to Window 2003, and now receive this error sporradically. It only happens a couple times per day, so the connection string is fine.
This issue seems to be server related, becuase all the same code and database ran fine on Windows 2000.
On my local pc all goes well,when i upload it to the server i get a file does not exist error , both the server and my pc have exactly the same folder tree and the same files ( ive checked it over 100 times now ) but the error still persists.
I have a folder called DirEscrita in wich i have put the dbf file to scan
for data , and i get this error when trying to do a simple select on it:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Visual FoxPro Driver]File 'trf.dbf' does not exist.
/exporta.asp, line 12
I know that it cant be a prob with the code , cause it works fine locally
( im on a XP PRO IIS 5.1) , could it be the server? ( IIS 5.0 )
I need a way to check if a certain folder exists. If it doesn't exist i want to create it. How can i do this?
View Replies View RelatedI am running WinXP Pro and have IIS 5.1. I am developing a web site locally - everything was fine until today when I tried to preview the site I got a 'class does not exist' error (in case you ask I have turned off friendly http errors and this is the message I get). This message is also displayed when I try to access my local host.
View Replies View RelatedI have an ASP script that checks results from a SQL query. The SQL query contains a CASE statement, so I have to perform a check to see if the object exists. Right now I have something like this: Code:
If objRs("TotPaid") = "" Then
But that just spits out a:
Item cannot be found in the collection corresponding to the requested name or ordinal Any takers?
if there is a function i can use within asp to check whether or not a file exist. Basically i have a list of products and i want to check if the file exists for the image and if it doesn't display an image i want to be able to dispaly a No Image Available image.
View Replies View RelatedI'm getting the following error on my locahost at work when I browse in IIS. "Class does not exist. " I created a web site in classic asp but I get this error. When I check IIS for the web logs it gives me 18:52:07 127.0.0.1 GET /PatientPortal/blank.asp 500
how to check in ASP using SQL database for existing user. I have some idea like do a select but I need the syntax.
View Replies View RelatedHow would I check to see if a column name exists in a recordset. Im pulling data from excel files and some have the first field as F1 and some F2 so im trying something like this:
If adoRs("F1") Then
but I get this half the time Item cannot be found in the collection corresponding to the requested name or ordinal.
Shouldn't the If statement fail there rather than throwing an error?
I am building and intranet and i need to check if a file exist in a folder on the network. The folders are in the R drive, the web server is on the same network as the other servers. I have tried this code below but I can only check the files on the website.
Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileexists("filename")=true then
Response.Write "Exist"
else
response.write "Doesnt Exist"
end if
set fs = nothing
I want to know how to check if the record I am about to add already exist? I would like to refer to the field of "icno" in the database. Code:
View Replies View RelatedI'm using vbscript in ASP to loop through and rename the files passed to it in a form. When I output the text to the screen of the filenames etc it's all working fine.
However, when I try to get the rename code working, if I select more than one, ASP tells me the 2nd/3rd etc file does not exist. The first one always renames ok.
I presume this is something to do with the Server.MapPath, but what exactly I have no idea! My code is below, can anyone see what I'm doing wrong? Code:
Look for wspwsp.dll in windowssystem32 and add IWAM_"computername" (ie IWAM_MYCOMPUTER if MYCOMPUTER is he name of your computer) account with read and write permissions.
The support person who helped me with this issue told me they will create a knowledge base article for it!
how asp can check whether a variable exist or not, like exist(name), or exist(hello)
return true and false.
for iCnti=0 to ubound(atbs2) 'Where atbs2 array has values like "description.txt,analysis.txt,query.txt....
if(fsdyn.FileExists(PATH&atbs2(iCnti))) then 'Where PATH variable holds the current path.
response.write("<br>File Exists: " & atbs2(iCnti))
end if
next
The problem im facing here is that the condition is allowing me to the loop, even if one of the file exists in the path, but my requirement is that, the if part should be executed only if all the files in the atbs2 array exists.
How can i make an if condition so that this problem is solved. Note: My array value is dynamic, meaning one time it may store 3 files and the next time it can store 30 .
Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??
I have an ASP page which has commands to access a SQL Server 2000 database. Ex:
rsDatabase.ConnectionString = "Provider=SQLOLEDB;Data Source=xx.xxx.xx.xxx,yyyy;Initial Catalog=ABCDEF;uid=john;pwd=smith"
This line returns the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
1. There is not much load on both the web and sql server and this is the only connection which I'm trying to open with the database.
2. I have tried connecting to the database using the System DSN, but it won't connect
3. On some days and at some times, the page works perfectly with no complaints.
I have a web form to publish data to a ms sql database. Everything works great on my local machine which I use for development. When I uploaded the form and connection file to our web server, I receive the following:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/psc/Connections/psc_lms_db.asp, line 5
Here is the connection string I am using: Code: