Search results for query: *

Hi, I have a web application that has been moved to a new server. The only difference is that is now running on a win 2003 server. I have ms sql 2000 and I am running crystal rep. dev. 8.5. I am generating a pdf file that I am saving on disk but I am also pulling it up to view from the web...

Hi, How can i prevent my form from beeing submited more then once? I have a DB app and i would like to be able to prevent more then one submit. Thanks, Linkan

Hi, I am trying to set up a query that makes a value positive i is is a certain transaction. Trying to set it up in a sproc but I just don't seem to make it work. What am I doing wrong here? Thanks, Linkan DECLARE @lngType int SELECT @lngType = (SELECT lngType FROM vLinkanTestView) IF @lngType...

Hi i am trying to make a nestled query to get the total sum of my accounts. My question is how to make a query to handle this? I have two tables. tbAccount lngAccountID strName 1 A1 2 A2 3 A3 4 A4 Now I want to SUM...

Hi, I have a report that prints out perfectly. I would like to have a new page with only information regarding the printed report. I want this to come as the last page. Can this be done? Thanks! Jonas

Hello, How can I print out a email message without the memostyle heading. From: Dent: To: Subject: I only want the message it self, anyone have any ideas? Thanks, Linkan

Hello, I have two dropdowns, they are not dependent but they both pull data from a DB. The first one is -CARS- and the second is -COLOR-. I want to make sure that if no -CARS- is selected -COLOR- should jump back to -COLOR-. Value for both -CARS- and -COLOR- is "-". This means I dont...

Hello, I have a website from where I want to send a formresult as a mail to the administrator of the site. I want send the email of the person who is logged in to the site as a replay address. I also want to send a subject and a message. The person who is sending is registered with a profile in...

Hello, I have a website from where I want to send a formresult as a mail to the administrator of the site. I want send the email of the person who is logged in to the site as a replay address. I also want to send a subject and a message. The person who is sending is registered with a profile in...

Hello, Okay here is my question. I found a nice client-side dynamic dependent list boxes. My broblem is that I am new to Java so maybe I am missing something easy. I manage to get one dependent listbox working, I use sql database and I write vbs asp. When I add the second dependent list box it...

Today my problem is that I want to use the right include file for language depending on who is loging in. Is there an easy way of doing this? Thanks for a great forum! //Linkan

Hello I am working with a sql 2000 db and I dont know how to write get a record cound from the following. Please advice. strSQL = "SELECT * FROM vJournal WHERE cus_id=" &GetCusId() &" ORDER BY topic_date DESC" Set objRs = Server.CreateObject("ADODB.Recordset")...

I have an DB in a SQL 2000, Name is DB1 now I want to make an exact copy that I can give a new name (DB2) and use for tests in the same SQL. How do I do this? Thanks, Linkan

Hello, I have upsized an Access DB and it works fine, my problem is that I am not sure how to connect the aplication that is built in access as well. It is linked to the DB that I upsized. Is there any way of doing this? Greatful for any help. Thanks, Linkan

Hello, How should I have set my access right in a case like this. I have a website www.mysite.com here I have a folder called /DB/ with a ms access DB file for passwords. How should the right be set if I want to be able to write to the db with ASP and still not letting people download the...

I am using a sql 2000 db from where I use data in my asp application. When I delete a record I would like a confirmation alert to pop up where I can cancel or ok my acction. Can someone give me some hints in this matter. Thanks for a great forum. Jonas

Hello, I am new to this and on my way to learning. I hope someone can help me with a trigger. I want to update status of one table when I insert a new threat in another. This is what I have come up with so far. CREATE TRIGGER [trg_Update_Status] ON tForumThread FOR INSERT AS BEGIN UPDATE...

Hello, Can I insert in one table and at the same time update another? I want to insert status for a thread in tbl thread but update the status for the topic in tbl topic. Thanks Linkan

Hello, I want to upload (from an ASP webpage)a excel doc with passwords to a table in my access db. Can someone please help me or point me in the right direction. . In my db the table holds. GROUP_ID (int) PW_ID (int index) PASSWORD My excel only holds PASSWORD. Thanks, Linkan

Hello, I want to upload a excel doc with passwords to a table in my access db. Can someone please help me or point me in the right direction. . In my db the table holds. GROUP_ID (int) PW_ID (int index) PASSWORD My excel only holds PASSWORD. Thanks, Linkan