Search results for query: *

I am using a text box control on a report to display data that is stored in a memo field in one of my tables.... but for some reason it cuts off after a certain amount of characters. EX. My table has a memo field with lets say 15000 characters in the memo field. When I try to display this in a...

Hi there. I was wondering if anyone might know of some software to keep track of who(ip address) is connected to my web server and for how long etc. I am using iis 5 with sql 2000 and asp pages that are used for members to login and do stuff.... But I was wondering if there was someway of...

I was going to write a stored procedure that gets passed 5 values. These values may or may not have changed from what they currently are in the tables. What I was wondering is... Should I compare the values being passed to the procedure to the values stored in the tables or should I just update...

Does anyone know how I can pass values to a stored procedure without using a recordset. I am using asp and interdev and would like to do it using server side vb code. Any suggestions will help. Thanks in advance. Bryant Moore

Hi there I need help with this I get this error ADODB.Recordset (0x800A0E78) Operation is not allowed when the object is closed. /MCERegister/_ScriptLibrary/Recordset.ASP, line 762 I am using a dtc recordset control on my page that is using a SQL stored procedure as its source. I am using SQL...

Does anyone know how to create DTC Checkboxes on the fly. I can create regular html checkboxes on the fly. Basically what I want to do is loop through a recordset and create a checkbox based on each record in the recordset. So for instance in the case below I am using a html checkbox. But I...

I am using Interdev developer and MSSQL Server 2000. I have written a trigger where when a change is made in a table(tblFirm) the trigger catches that and updates another table(tblExternalTeam). So when the firm name is updated in the firm table the trigger updates any of the same firm names...

I am using Interdev developer and MSSQL Server 2000. I have written a trigger where when a change is made in a table(tblFirm) the trigger catches that and updates another table(tblExternalTeam). So when the firm name is updated in the firm table the trigger updates any of the same firm names...

I need an expert opinion on what I should do. I have an asp page where I want to retrieve records but I have to place certain records under certain headings. So I need write the heading then output the records. In order to do this I need to go through all the records ten times for each...

I am a beginner with IIS and do not know how to get it working properly. But what I have done is this. I am using VI 6 to develop my asp pages and I am using IIS 5 to put them on the web so what I have done is set my home directory to C:\Inetpub\wwwroot\NetworkForms. I can access the main...

To keep it kind of simple in my explanation... I need to be able to be able to insert multiple records into a table from a button click event. I want to set up a loop in the code for the button click event that will loop through one table retrieving records while inserting into a different...

This is my code. Private Sub btnRunQuery_Click() Dim dbs As Database, rst As Recordset ' Modify this line to include the path to Northwind ' on your computer. Set dbs = OpenDatabase("C:\AccessDB-equinoxserver\Equinoxserver.mdb") ' Count the number of records with a...

Hi there. I am having problems with displaying the proper information in a report. I want to be able to edit the source of the query. I dont like just selecting fields and stuff. I want to be able to actually write the query myself. If anyone knows how to do this let me know. In the mean...

Has anyone ever come across this error and known exactly what it means. Any help would be appreciated. Thanks

I have a report where I want to display the company logo. I am using access 97 and in the database I am storing the name of the company logo but how do I display it. I tried using an object frame and an image control and I tried setting the control source to c:\pics\[flgLogoName] but this will...

I want to run the same code as the submit button if the user just presses the return key in a text field. Just makes it easier for the user but I dont know how to check for a return key press. Any help would be appreciated Bryant

my dtc recordset will not display properly if there is a dtc grid on the same page. I have a loop that goes through the dtc recordset retrieve all records but for some reason it will only work properly if there is no dtc grid present on the same page. I need to have both working. Can anyone...

I have a dtc recordset on my page that loops through and retrieves records pertaining to a certain id. On this same page I also have a grid that retrieves different data pertaining to the same id. Anyway the problem exists after pressing the grid navigation buttons. Once a grid navigation...

I have an sql query that will execute fine if tested in sql server manager. Once I add a recordset to my asp page and set the appropriate paramaters only one of the parameters gets passed to the query. here is my buttonclick method code Sub btnSearch_onclick() 'purpose: set the parameters for...

I know how to check for a valid email in javascript. But I am not sure how to go about it with vbscript in asp. Is there a substr() function in VB also Any help would be greatly appreciated