Recent content by Borracho1

thanks for the replies due to some problems i wasnt able to post sooner. Dagon, your interpretion is indeed what i am trying to do. 'on insert - just sends the signal for retrieving card data' 'on update - interprets the status and <i>now converts the data</i> Taupirho, trigger coding is...

hi, a)when insert is done, trigger is fired and passes status and a pk-field to a stored proc.If status is initial i am starting a dbms_alert.signal. The coding that is waiting for this alert now does a select from communication and communication data. Inserts the reply in communication data...

Hi, i'm currently facing a problem with a trigger. I created 2 tables: -communication -communication_data The trigger i created for communication is of type ( after insert or update on status for each row) whenever an insert is done in communication the trigger is raised and a dbms_alert is...

thanks for the reply. Will search for some information about this.

Hi, I have made a website with a promo page. So the client should be able to edit text and layout (insert enters change font size and stuff like that). I thought to solve this by using an xml file with some paragraphs and titles but this still isn't good enough. Cause it still limits the...

if you only need to send a total amount you could use this, there is also an option to send your entire shopping cart but i don't use that. It's perhaps not the safest way but it's doing it for me. sub btnpaypal_click (s as object, e as eventargs ) Dim str3 as string Dim sb As New...

changed it to parameters and now everything is working. Thanks for all the help & "AND tblmeeting.Meetingdatum >@datum4" dim dte2 as date dte2 = Now.ToShortDateString() drpoCmd = New OleDbCommand(drpsSQL, drpoConn) dim objParam as OleDbParameter objParam =...

I am sorry but this isn't working. Like i said in the first post if i use the following i get exactly one record. I need to put the double # or others it isn't working either. If i remove two # i get different errors. "AND tblmeeting.Meetingdatum>#" & #8/03/2006# & "#" Like already mentioned i...

ca8msm, i did it exactly like you said, made my query in access and assigned a value to the variable. I saw some other posts and thought that my where clause was right but for some reason my string field could not be compared with a date in an access table. The solution was put in a datareader...

first thanks for your reply I aint at home right now so i can't test your suggestion. I apologise if the solution is already on the forum but i wanna say that i searched the forum first and found some similar posts and wanted to reopen one but this one was already archived. The solution in...

Hi i am using following sql statement to filter records of an access db but it doesn't display any records or gives an error when i try it with a variable. With a normal date everything is working fine. "AND tblmeeting.Meetingdatum>#" & #8/03/2006# & "#" i tried also to use the format string...

ok thanks a lot for your help, i owe you a beer if you ever visit belgium. Borracho

thanks for the quick reply. But i have a dutch version and i can't find an exact translation of create or application (if a rightclick the name of my directory with my aspx pages in there is explore, open, delete,all taks, properties and some less important i think). Also have the option new -...

I have several aspx pages in a folder under my wwwroot and now i want to disable that people can enter one page by typing it directly in the browser. Therefore i read some posts on forums and tutorials and made a loginpage with following line if the password is true...

Thanks a lot for the last two reply's when i used them together the onitemcommand and the enableviewstate of the repeater i finally got it to work. Thanks a lot both of you for the reply. So I finally have a great day. Thanks alot Borracho