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

..."0", "treelistcontrol/icon_folder.gif", false, array(cstr(rsAgreements_Supplier("ID #")),"","","","","","","","") rs.source= "select * from supplier_docs where ID='" & rsAgreements_Supplier("ID #") & "'" rs.open() ccounter=counter do while not rs.eof counter=counter+1...

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

...Or qryAnnexSummation_View.SubCategory Like 'Equa%' Or qryAnnexSummation_View.SubCategory Like 'EEO%' THEN 'WING' ELSE qryOrg.Org END, qryOrg.* FROM qryAnnexSummation_View INNER JOIN (qryOrg INNER JOIN QryCategories_View ON qryOrg.Org = QryCategories_View.Org) ON...

Hi Chris: Thanks, worked just great!!! Really appreciated your help. Cheryl

...Set rsSuspenseLog = Server.CreateObject("ADODB.Recordset") rsSuspenseLog.ActiveConnection = MM_sar_STRING rsSuspenseLog.Source = "SELECT * FROM dbo.QryUnionBase_ViewRpt" rsSuspenseLog.CursorType = 0 rsSuspenseLog.CursorLocation = 2 rsSuspenseLog.LockType = 1 rsSuspenseLog.Open()...

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

...Then I click the OK button on the message, which goes away. I check the code for the page and Dreamweaver generates the following code: <% ' *** Restrict Access To Page: Grant or deny access to this page MM_authorizedUsers="1" MM_authFailedURL="../../ADMIN_ACCESS_DENIED.asp"...

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

...handling logic desinged ' to trap any non-fatal errors (such as failed database connectivity) and ' display them to the client browser. ' '**IMPORTANT** Even though we disable the extended error messaging of the engine 'fatal errors can cause an error dialog to be displayed on the Web...

...INSERT the values needed later into the temporary table INSERT INTO #ARSRolesMembers(DbRole, MemberName, MemberSID) EXEC sp_helprolemember SELECT * FROM #ARSRolesMembers where #ARSRolesMembers.DbRole = @DbRole This stored procedure provides me with a list of the roles and members who belong...

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:" &...