Search results for query: *

I tried to access UDF(that is stotred in 2nd serevr) via the Linked Server but I discovered that only tables and views can be access with the linked server (If i'm right). how is possible to access the UDF from one sql server to another ??? Rgds, zuZa

Dear all, this peace fo code is not working, enntering into table records through looping for a given value(limit): a - is value that user enters(selects from combo in this case), so adding of records should end to this up to this value. This code below is looping to the end is not stoping to...

Dear all, I will start wil an example, it is a table with history like: Claimno ---- Status ---- Datest ds001123 notified 12/01/04 ds001123 Case closed 12/03/04 ds001123 decision 12/09/04 By the rule 'Case closed' should be the last status, so how to find...

Hello there, I'm asked to develop the automatic transfer from standardized forms (word docs) to a standardized excel spreadsheet? We have data (name, addresses, etc.) that is currently copy and pasted manual from the word documents to the excel spreadsheet. Can this be automized somehow with...

Hello there, I'm asked to develop the automatic transfer from standardized forms (word docs) to a standardized excel spreadsheet? We have data (name, addresses, etc.) that is currently copy and pasted manual from the word documents to the excel spreadsheet. Can this be automized somehow with...

hello there, I have to display in output only first field of the table called Claimno and there are 4000 records approximately.But to loop through these normally with one column is not the point. How can it be displayed for intance: DS002233 DS009971 DS009988 DSr.... DS004455 DS009973 DS009991...

Hello there, I want the results page of form action to pop-up, but is not working, can please somebody help me on this?? I have a function : <script language="JavaScript"> <!-- function openWin(fajlli) {...

Dear all, I will apreciate if somebody could help me on this one : SELECT qryPubication.ClaimNo, qryPubication.StreetNameP AS StrA, qryPubication.StreetNoP AS StrB, IIf(IsNull([StrB]),[StrA],(LTrim([StrA])+", "+[StrB])) AS StrC, IIf(IsNull(lTrim([BuildNo]))," ",(lTrim([Buildno]))) AS Buil...

dear all, I want to add print version of the asp page, for html page I found a javascript file, like this: <script language="JavaScript"> var gAutoPrint = true; // Flag for whether or not to automatically call the print function function printSpecial() { if (document.getElementById != null)...

Hi there, I'm trying to make charts with ASP via OWC component/control. I download owc10.exe from Microsoft Downloads and I install it in my PC, but OWC.Chart is not valid - invalid class. What I have to do else in order to install this component on IIS and continue making charts. Thanks a...

Hello there, can you please suggest me on HOW TO DESIGN CHARTS WITH ASP WITH A SOURCE ON SQL-SERVER. Is there a way to find any free source code on internet and to design it by myself or I heard that you can buy controls that somebody else has design it and intergrate it in my website. Thnx in...

Hi there, I want to execute UDF with input parameter claimno = request.form(claimno) ... how do I have to write the statement, for instance: str="select top 1 statusnew from getNewStatusByDS(" & "'Claimno'" & ") order by datemax desc" Or in different way ... maybe completely wrong. ciao, ZuZa.

dear all, I want to accees a table from Query analyzer which is in another server - they're in the same domain/network (both of the servers). OK error is telling me 'Execute sp_addlinkedserver to add the server to sysservers.' I found the Stored Procedure - "sp_addlinkedserver", but I can not...

Dear all, untill now my asp pages was on the same server as sql-server, so I'm connected to sql-server with dsn and normally create (give) access to the iusr_machinename (default IIS user) in order to work the connection between asp and sql-server. But, now I have asp pages on server Intranet...

Dear all, I'm designing database/vb6 application with sql-server source, and I need to read ID barcode which identifies the user and Case (it's file hard copy). To both of them we will put barcodes with barcode writer. Do I need simple barcode reader for this (and writer as well) or some...

Hi all, I'm facing a problem I have htm page that somebody else has made it but there's text box there for instance called DSNo & button as well 'GO'. I have to run an ASP page that will take from this text box what the user will write and pass it to my ASP page (as pop-up new page) that is...

Dear all, I have a status table where the DS# are entered as history like : DS# Status date DS000001 --- claim received -- 12/03/2003 DS000001 --- notification completed -- 12/06/2003 DS000002 --- claim received -- 21/02/2004 DS000002 --- HPCC...

Dear all, I have problem using the "case" statement in SQL-Server, that the same I use in Access source. Here is the code : Select Case RecSeti.Fields("UserRole").Value Case "admin" %> <!--#INCLUDE FILE="menu_admin.asp"--> <% Case "user" %> <!--#INCLUDE...

Hello there, I have a program/database developed with adp, which some other developer left it to me to administer and to make chenges when the owner ask. The problem is that prervious developer have hidden some forms and all reports, and me I have to go in now and to change something. I go in...

Hello there, can somebody tell me how can I configure LDAP server on Microsoft Exchange 2000 server to retrieve address book from it.(client from LDAP exchange server) Thanks, ZuZa.