Search results for query: *

Hi: I have a problem to resolve regarding a table named UIC that is located in two separate SQL Server 2000 databases called 'DatabaseD' and 'DatabaseN'. Both of these databases are on the same server. I want the UIC table in 'DatabaseN' to be synchronized with the UIC table in 'DatabaseD'--...

Hi: I'm working on a project using ASP and SQL Server 2000. I have a SQL Server 2000 database that contains a table called 'Supplier_Docs' that contains a field called 'doc_weblink' (varchar data type). The 'doc_weblink' field holds the names of PDF files (e.g. Budget.pdf) Here is some...

Hi: I have a web-based application that uses ASP with SQL Server 2000 in the background. I have a field called ‘weblink’ within a database table that list the names of pdf files (that includes the .pdf extension). These documents are stored on a network share drive. Using ASP code, I have...

Hi: I'm developing a web app using Dreamweaver MX (ASP, ADO) and SQL Server 2000 for the database. I have a stored procedure called 'procQryByOrg_3' that needs to have 4 parameters (@Supplier, @Agreement, @Includes and @Excludes). Here is the code for the stored procedure. Sorry about the...

Hi: I'm developing a web-based application using Dreamweaver MX with ASP on the front-end and MS SQL Server 2000 on the back-end. I have the following code that creates a record set within Dreamweaver MX and I'm trying to use the RecordCount property of the record set to get a count of the...

Hi: Does any one have a link to very detailed instructions (with pictures if possible) on how to create a login in Dreamweaver MX that uses the Username, Password and Access Level. I need to control access to a bunch of web pages on my site. The Access Level is going to be set to just 2...

Hi: Below is the code for an ASP page that I trying to use to generate a report that I created in Crystal Reports 8.5. Some of this ASP code was generated using Dreamweaver MX (i.e. MM_sar_STRING for the connection string). Begin ASP code --------------------------------------------- <%@...

Hi: Below is the code for an ASP page that I trying to use to generate a report that I created in Crystal Reports 8.5. Some of this ASP code was generated using Dreamweaver MX (i.e. MM_sar_STRING for the connection string). Begin ASP code --------------------------------------------- <%@...

Hi: I have been using a system stored procedure called 'sp_helprolemember' that I used within a user defined stored procedure called 'procARSRoles' within SQL Server 2000. When I execute the following user defined procedure that contains the system procedure, it works just fine: CREATE...

Hi: I'm working on a web-based time and attendance application in Dreamweaver MX with an MS SQL Server 2000 database on the back-end. I have a need to add new records to a tabled in the database in a batch, if possible. I have a table called 'Weeks', that contains the following fields: id...

Hi: I'm working on a report in Crystal Reports version 8.5. I have a formula field that calculates number fields (sums the two fields). Here is the formula: Sum ({qryAnnex_View.NRCost}, {qryAnnex_View.Categories})+Sum ({qryAnnex_View.NRWorkyearCost}, {qryAnnex_View.Categories}) What is the...

Hi: I am having trouble with formatting a number field that has some null or blank values within the column. I'm using ASP in Dreamweaver MX and I have a field called 'Manpower_sum'. When I try to open an asp page for a record that contains a blank or null value in the 'Manpower_sum' field, I...

Hi: I am trying to convert a complex immediate If statement (IIf) that was successfully generated in Access 2000 to a comparative one in a Crystal Reports 8.5 formula. Here is the syntax in as it is in Access 2000, an IIf statement: =IIf(IsNull([Revd_Coord]),""," Received on:" &...

Hi: I have a stored procedure that I'm trying to create to drop an existing table then re-create the table, because each time a SELECT SQL statement is run on the table which is based on an INSERT INTO statement from a another table the data needs to be grouped accordingly. Here is my stored...

Hi: I am new to Crystal Decisions' Crystal Reports. I am using version 8.5 and I am having problems with formulas. This is my first formula. I had a complex report in Access 2000 that used the following nested immediate IF statement for a calclaued field on the report...

Hello: I need help with a SQL INSERT INTO SELECT statement. I am trying to insert some data into a table called Months based on a SELECT statement from the table called Weeks. I'm using SQL Server 2000. First, I have a SELECT statement As follows: SELECT last_name, first_name, SUM(bhrs)...

Hello: I have a ADP project that I'm working on using SQL Server 2000. I have a form that needs to be available for both entering new records(updatable)and viewing. Currently, the form is bound to a stored procedure called 'procqryAnnexSummation' as the Record Source. As a result of this...

Hi: How can I write a CASE statement(s) in SQL Server 2000 with several 'OR' operators in the logic? I have a SQL statement that I'm converting from Access 2000 over to SQL Server 2000, that contains a WHERE clause with several immediate IF (IIF) statements that contains several 'OR'...

Hi: I am in the process of converting a Access MDB to an Access ADP. I'm using an Access 2000 project (ADP) with a SQL Server 2000 backend. I would like to get any suggestions on how to resolve an issue that involves properly converting a SQL statement from Access 2000 to SQL Server 2000 --...

Hello: I'm trying to use the Input Parameters property in an ADP Project. I'm using SQL Server 2000 as the database server. I've tried using the following syntax in the Input parameters property on a report object within the ADP project: @ID = [Forms]![FrmSelectAnnex]![Text1], @ID_Num =...