Hello All, I have a validation, replacing quotation mark in my dll as soon as surname or first name has been passed from my form. The code is : CStr(Replace(Trim(surname), " ' ", "$0")) The problem is when I type a surname = "O'Brian" the data does not go to the database and has internal server error. Can anybody suggest any other way I can liminate this problem? Many Thanks :rolleyes: Bravo Two Zero A pen is mighter then a sword.

Hello All, :rolleyes: I have a validation, replacing quotation mark in my dll as soon as surname or first name has been passed from my form. The code is : CStr(Replace(Trim(surname), "'", "$0")) The problem is when I type a surname = "O'Brian" the data does not go to the database and has internal server error. Can anybody suggest any other way I can liminate this problem? Many Thanks Bravo Two Zero A pen is mighter then a sword.

Hi All, I am having problem with bof and eof. can any body please help? Error Type: ADODB.Field (0x80020009) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. :rolleyes: Many Thanks.. Bravo Two Zero A pen is mighter then a sword.

Hello All, :rolleyes: I wrote a com object to suck all the information and process in the dll including submission into database. My code is: Dim myobj As New clsMyObj with myobj .name = CStr(FirstName) and so on .ConnectionString = strConnection .mySubmission end with mySubmission calls the function and submit to the database. What I gathered is that my dll is breaking because of the difference of the datatype. My question is any way I can check the status of the myobj if the data process is not been submit? If yes How? I can check the database state by : Dim myconnection, stat myconnection = As New ADODB.Connection If myconnection .State Then stat = true else stat = false end if Any thoughts please?? Most greatful. :-D Bravo Two Zero A pen is mighter then a sword.

Hi, Would you be kind enough to help me to create Next and previous in asp page or point me in the right direction Please! my code is: <% Dim oConn, rstData listData function listData set oConn = Server.CreateObject("ADODB.Connection") set rstData= server.CreateObject("ADODB.RECORDSET") if not oConn.State then oConn.open Session("CC") end if with rstData .CursorType= adOpenForwardOnly .LockType = adLockReadOnly .ActiveConnection = oConn .Source = "sp_e_data" .CursorLocation = adUseClient .Open end with end function %> Much appricated. :rolleyes: Bravo Two Zero A pen is mighter then a sword.

Hi All, I have created an ODBC connection called 'Reports'. In my asp page, I want to call Crystal report to view the data via ODBC 'reports '. My code is: ' Set the location set mytable = session("myReport").Database.Tables.Item(1) mytable.SetLogonInfo "reports", "Testing", "username", "password". I am calling 'report' the ODBC connection to connect the database and its not doing what its should be. Don't worry about the Crystal report. I just need to know how the odbc connection works in terms of asp pages.Please can anybody help, how to call odbc in order to work this functionality !!! I will be most greatful.. :rolleyes: Bravo Two Zero A pen is mighter then a sword.

:-D Many Thanks Bravo Two Zero A pen is mighter then a sword.

:rolleyes: Hi All, I am trying to retrived data from SQL server in my asp page via ODBC connection. I have done the ODBC connection via administration tool. MY Code is: <% dim oConn, strSQL, rstMovie, Records set rstMovie = Server.CreateObject("ADODB.RECORDSET") Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=MSDASQL; Driver={SQL SERVER}; SERVER=localhost; database=Movie2002; UID=test; PWD=test;" strSQL = "Select * From tbl_movie" rstMovie.Open strSQL,oConn,adOpenForwardOnly,adLockReadOnly %> when I am trying to view the page on the browser the error message is 'page cannot be displayed'. The error message relates to ODBC connection I think. Can anybody help?!! Many Thanks. Bravo Two Zero A pen is mighter then a sword.

Hi, In my form, I have two text fields called txt1 and txt2. I am using javascript pop up calender and creating date value for txt1 and calling a function onchange="popVal()" in txt1. function popVal(){ window.document.form1.txt2.value = window.document.form1.txt1.value } this does not insert the txt1 date value into txt2. I tried onblur, onfocus as well. can any body help?! I will be most greatful. Thank you. Bravo Two Zero A pen is mighter then a sword.