Search results

  1. H

    Help with adding new records

    Hi, I don't know much about how to add records using .AddItem method. This is what I have used but it doesn't work ---------------------------- set con=server.createobject("ADODB.connection") set rs = Server.CreateObject("ADODB.Recordset") con.open "provider=microsoft.jet.oledb.4.0;data...
  2. H

    Displaying certain no. of records

    I have an access database - There are about 1000 records in a table. What I want to do is display 50 records on each page. The code I have used is given below. The problem with this is that it continues until all records are displayed (which means 100 records or so). This not only looks bad but...
  3. H

    Is there a way to replace characters?

    the code that you suggested hasn't worked in my case. dont know what's going wrong but it isn't working --- i copied and pasted your code. also can you explain the last line in your reply (Kodo) about SQL injections...
  4. H

    Is there a way to replace characters?

    In ASP, is there a way to replace characters. What I mean by this is that I have a form in which users can submit their comments. Now what they do is they at times even use the singl-quotation (also known as an apostrophe) in their messages. Now when the message is being added to the database...
  5. H

    Unspecified error

    good! it worked wonders! thanks a lot
  6. H

    Unspecified error

    i have used the following code on my website: Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open strCon Set rsConfiguration = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT tblConfiguration.* From tblConfiguration;" rsConfiguration.Open strSQL,strCon (this is line 152...
  7. H

    Sending email with ASP

    well.... all the errors that i was coming across have finally been resolved! now i would like to ask one more thing... is there a way i can send emails to anyone with a webpage in the email - like the newsletters that one gets often. i should just need to specify the URL in the script and it...
  8. H

    Sending email with ASP

    I used the new code as quoted on the above link the new error that i get is: error '8004020f' (line 20) please help!!! btw my hosting company said they used windows 2000 server
  9. H

    Sending email with ASP

    Thanks a loT!!! well i did add server to that - made it server.createobject now i get a new error - it says: The "SendUsing" configuration value is invalid. (line 8)
  10. H

    Sending email with ASP

    My new code and new problem! This is the new code i used: <% Set myMail=CreateObject("CDO.Message") myMail.Subject="Test Mail Subject" myMail.From="webmaster@mydomain.com" myMail.To="receiver@domain.com" myMail.Bcc="receiver@domain.com" myMail.TextBody="This is a message." myMail.Send set...
  11. H

    Sending email with ASP

    I am using the following code to send email with ASP but I get an error which says: Server.CreateObject Failed emailsend.asp, line 5 <% For Each x In Request.Form message = "my message" Next set smtp=Server.CreateObject("Bamboo.SMTP") smtp.Server="webmail.mywebsite.com"...
  12. H

    UPDATE query problem

    What should i do now? The error is also coming in the insert query too... Please help ASAP because I have to start my site soon. The problem is that I am not getting any problems running on PWS/IIS but its coming on my server!
  13. H

    UPDATE query problem

    I am facing some unknown problem on my server regarding a query. I have used the following query in my ASP page: properlogin="UPDATE MEMBERS SET ProperLogin=True where username='" & username & "'" con.execute (properlogin) This query is running fine on my PWS/IIS but on the site it says that...
  14. H

    How to rank data result

    I have a table which has got the following fields: Name and Points I want to create a third fieldw with the name of rank which should give automatic results of rank that is the one with the maximum points should have '1' written in his rank column. Similarly, all rank fields should be filled...
Top Bottom