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 Chris: Thanks, worked just great!!! Really appreciated your help. Cheryl

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...

Yes ArtieChoke, I am trying to add them to the WHERE clause. Any ideas as to the best syntax to use? Thanks, Cheryl

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 Tarwn: Works like a charm!!! Thank you very much for your help. Thanks forti as well. -Cheryl3D

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 -k: I noticed that I used the CDate conversion function which was incorrect. Thanks for pointing that out. Yes, I'm glad that Brian figured it out too. I am a newbie at creating reports in CR. I was not aware that CR could handle nested immediate IIf functions like in MS Access. In...

Thank you very much Brian: It works just great!!! The only thing that I had to do was slightly change the very last portion ..., "")), so that the formula code that worked ended up looking like: IIf(IsNull({qryAgreement.Revd_Coord}),""," Received on:" &...

Hi -k: OK, fair enough. Here is what I used as a formula: IF IsNull({qryAgreement.Revd_Coord}) then " " Else "Received On: " + ToText(CDate({qryAgreement.Revd_Coord}),"dd-MMM-yy") + IF IsNull({qryAgreement.Sent_to}) then " " Else "Sent To: " +...

Hi -k: First thanks for the catch with the "and" you're correct I forgot that in CR + is used for concatenation. I tried your SQL statement above in the formula. I checked the syntax and received the message from CR that there were no errors found. I saved it successfully. But when 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:" &...