Search results for query: *

Hello, I am using CR v10. I have a formula field that conditionally concatenates database values together with carriage returns. The resulting string will be between 1 and 3 lines. (If it is important, the records that I am concatenating together are not from different database rows, but all...

Hey, I'm using Crystal Reports 8.5. I've been on this problem a while. I need the ability to dynamically change the sort order of a group based on a input parameter. The group has to sort either by sum(price) or alphabetically by its title. Its automatic that it sorts by its title, no...

Here’s my dilemma: I have a system in which users have a balance. A user’s balance is basically the sum of their credits and debits, inputted as transactions. In order to avoid a sum calculation every time a user’s balance is requested (there may be MANY transactions), the balance is just a...

I have a publication database with a subscriber that is already initiated and replicating fine. Now I've made a sproc change at the publisher and I want to push the change down to the subscriber. So I start the snapshot agent. Even after the snapshot generation is complete, the subscriber...

Hello, Here is my situation: I have a database that is merge replicated down to client. The client hadn't replicated for several days, but much data was entered in on the client database. An update script was run on the publisher that did something inconsequential to the data (like trimmed...

This is my setup: Publisher/Distributor: sp3-ified SQL Server 2000 Subscriber: sp3-ified MSDE I have merge replication setup and the subscriber is anonymous. Changes to the database on the publisher side are merged fine into the subscriber database, but changes to the subscriber database are...

Hey, I'm trying to run a VB app I wrote that has worked fine in the past. Now everytime I run it, I get that IE Security Warning prompt that asks me whether I want to install and run "eConnect v1.0.0.1", authenticity verified by Thawte Server CA. Of course I never say yes. My app...

hey guys, ok, heres my problem. I have a view that has an instead-of insert and instead-of update trigger on it. This works fine if I'm directly connected to the server. I can open up query analyser and call update view1 set column1 = 'data1' where columnid = 1 and it works just fine. The...

Is there a javascript event that is fired on a File input form variable after the OK button or Cancel button is pressed on the file dialog box thats launched from the Browse button? Thanks, Cheyney

Is there any command line for ghostscript to parse a page size/ page count from a postscript file? Thanks in advance, Cheyney

Does anyone know where I can find microsoft's WinHTTP 5.0? Its been taken off of msdn and replaced with 5.1 (not backwards compatible). Thanks in advance, Cheyney

Has anyone queried SNMP devices from SQL server. I would like to do this in a stored procedure. I know I can probably do this using the sp_OA... stored procedures and an SNMP dll...which brings me to my next question (not especially suited for this forum) -- has anyone found a better, free dll...

I am writing a VB application that autoplays on a cd, and I'm wondering if there is a silent VB runtime installer that I can use that checks if the proper runtimes are installed on the computer and if not, register them. Has anyone used something like this before? Thanks, Cheyney

Is there a way to access a list of history of DLLs that IIS accesses with CreateObject? thanks, cheyney

hello, I have a session variable ("Price") that I assign values to. I haven't been extremely careful whether I assign numbers or strings to it, but lets just suppose I might assign a string one time and a number another time. Now, when I try to write out price with...

Hello, I just used a script posted at: http://databasejournal.com/features/mssql/article.php/1440501 to rename one of my databases, and the dbo user on that database disappeared. How can I recreate this guy? when i try to add him with login name "sa" and username "dbo" i...

Hey, I'm remotely running MSDE and i forgot to set the default value on a table column. How do I set it programmatically? I've tried this code: ALTER TABLE tblInventory { Alter Column QtyOnHndID { set DEFAULT newid() } } go but i get the folling error: [Microsoft][ODBC SQL Server...

Is there anyway to change the background color, highlight color, and font color of a menu? Cheyney

I know of many programs that color sql syntax, but I'm wondering if anyone knows of a program that will save the coloring in a formatted file, preferrably HTML. Any help appreciated... Cheyney

Is there any way to write variables directly into the request object of a target page? something along the lines of response.form("one") = 1 response.redirect("one.asp") then on one.asp response.write (request.form("one")) ? or is the only way to pass variables...