denny911

Hello,Since I really didn't know where to post my question, I'm posting it here..I've got a really nice gallery script on my ASP (MS Access) site. It only scans its default image folder and displays images along with their comments.I've integrated file upload, and everything works pretty fine.BUT.. This script doesn't enable moving images or deleting them directly from the page (with administrator privileges, of course) but it simply lists and shows images.Now, I'm wondering if anybody knows about some script that will enable moving and deleting (or, at least one of the mentioned) images from any folder in my root directory (of course, i would be using it independently from my gallery script)..Thanks,Denny

if that piece of code isn't in the 1st line of code, thaT'll cause the errortry to put it in the first line, maybe that's the solution

Hello,I have asp adrotator set up on my site.. im using .jpg banners.Now, i wanna know is it possible to use .swf (flash) files, alone or along with .jpg and/or .gif files?Thank you

Hello,Recently I decided to make an info portal of my own (I chose ASP). I've started from 0 knowledge of ASP and later I learned that using MS Access databases is not very good idea if you plan to have many users at the same time.Now, what I want to know is whether it is possible to use MySQL with ASP pages? Or should I better start learning PHP (as well as MySQL) and transform my current portal from ASP to PHP site?If you like, go to http://www.uskportal.info and take a look.Thanks for your replies!

Hello,Recently I decided to make an info portal of my own (I chose ASP). I've started from 0 knowledge of ASP and later I learned that using MS Access databases is not very good idea if you plan to have many users at the same time.Now, what I want to know is whether it is possible to use MySQL with ASP pages? Or should I better start learning PHP (as well as MySQL) and transform my current portal from ASP to PHP site?If you like, go to http://www.uskportal.info and take a look.Thanks for your replies!

thank to both of you, guys--the problem was in other parts of code, but i had to use the hint from BOLADO's first post.Thanks again!

unfortunately, this didn't help.. the ERROR message is still there..Anything else?

Hello,In the table "mytbl" there's a field named "hits". I'm trying to make this piece of code below increase the value of that field by one. <% Set conn = Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.Mappath("database-path.mdb"))SQL = "UPDATE mytbl SET "sql=sql & " VALUES "sql=sql & "hits ='" & hits+1 & "'"sql=sql & " WHERE ID = " & ID & ""on error resume nextconn.Execute sql, recaffectedif err<>0 then Response.Write("Error!")else Response.Write("Record Added")end if%> Below this is the code that shows the value of the field hits and it works just fine. The problem is after I refresh the page, that value is NOT increased by 1, as it is supposed to be (the ERROR message appears but database's value is displayed). It only shows the value as it is, every time I refresh the page.Any suggestions?Thanks

you see, i know for sure that the time difference is 7 hours. in my database i have the date/time fields which are filled automatically since their default value is set to Now()How can i change the time format of my hosting server to show the current time + 7hours and also to show date in this format: 31.12.2005 and not 12/31/2005?Thx

Hello everyone,i have uploaded my site for testing purposes. i use an MS database and when i open my site from localhost, dates and times are shown like this:28.12.2005 15:04:29But, when i open the same page from internet, the same date and time are shown like this:12/28/2005 8:04:29 AMi realize that the server time is used in both cases. since im in bosnia and herzegovina, the first date and time format are what i want.but, my hosting server is probably somewhere in USA (since the other time is 7 hours behind).Now, i want to know if there is any way to make my server display GMT+1 time instead of that of my hosting server?Any suggestions, anyone?THX

i think you should have another .asp page that will be placed in form's action, something like this: <form action="confirmation.asp">, where you would put: Your subscription has been confirmed! or something like that..i'm just a beginner in ASP so.. ;-)

i'm not sure that i understood what you want to do?

You see, i think the problem might be in this:sql=sql & "'" & Request.Form("comment") & "')" (there is no ";" after closing bracket..Try insert it:sql=sql & "'" & Request.Form("comment") & "');"and let me know if that was the problem.

ok, but how am i supposed to do that? should i open a database connection and thenSELECT * FROM counter..can you continue? thanks for your response if there's gonna be any..Denis

Hi,If you want, go to my testing site at hhtp://d.1asphost.com/krajinaonline/ and take a look so it'll be easier to understand what i want.I want to add the code that will increase value by "1" every time user opens a page."This article is commented: xx times" (i already have this one and it's working)"This article is viewed: xx times" (on my page, here i put the same code as above but i've added (+8) just to make it seem different from above - it does NOT what it is supposed to)so, after the first user reads an article, there should be "1 times", and after another user reads that article, there should be "2 times" and so on..i suppose the value should be stored in my database, but how? And what code should i use?thanks!