Search results for query: *

Hi, When I try & do this (in SQLServer v7 sp3): alter table tblCountry add constraint FK_tblCountry_tblCountry FOREIGN KEY (ship_to_country) references tblCountry (countryky) I get the following error: Server: Msg 547, Level 16, State 1, Line 1 ALTER TABLE statement conflicted with COLUMN...

Hi, I'm running Domino Server 5 on NT Server 4 (SP6). I'm trying to provide access to user's mail via a web browser. I currently can log in to notes via the client, but on doing so, certain screen elements are not rendered in the browser & when the cursor is passed over them return messages...

Hi, I've had a couple of 56kbps modems installed on COM2 on an NT Server4 machine. (I don't think it matters, but the models are a Maestro Jetstream V90 Voice external & a 3Com US Robotics 56K Fax/EXT). Both install OK & are instantly recognized by Remote Access Server (RAS). Both will answer...

Hi All, I wanted to re-install RAS on NT Server 4 (Service Pack 6) & so ran Windows NT 4 Set-up from the CD (thinking it would give me software (re-)install options. To my horror, it seemed to be just doing the stuff for a system re-install & now, after exiting Set-up, I find an extra...

Hi there, I've got a query which returns a result set like this: ColA ColB ColC ColD A1 B1 C1 D1 A1 B1 C2 D2 A1 B1 C3 D3 A2 B2 C4 D4 ie, multiple values of cols C & D for a value of A & B (which are 1 to 1). I want a...

Hi All, Whenever I have a page that invokes another via response.redirect I get a "HTTP 500 - Internal Server Error" from our web server (IIS III on Win2000). Any ideas? T.I.A GAM

Hi All, I'm quite new to ASP & have a (probably) simple ASP syntax error. The code is: ... <% If blnFromRS AND rsTopArea.RecordCount > 1 then%> ... to which the VBScript compiler responds: Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: ''...

Hi, I had created a whole set of triggers which controlled the data entered into a system. I had tested them with T-SQL statements in a test database & they seemed to work fine. I've since dropped all of them & recreated some of them in the test db & one in the prod database. None seem to...

Hi, We have some Japanese characters stored in Unicode format. Does anyone have any idea how we would get them converted to 8-bit for display in a Web page? Navigator apparantly can't handle Unicode, at the moment. T.I.A, GAM

Hi, At the moment, we seem to have only 2 ways of connecting to SQL Server 7 (running on NT 4): 1 - We log in with no password supplied & then have to supply a password each time we wish to do anything in any of the databases. 2 - We log in with password already supplied & don't have to...

Hello, I get the above message as a pop-up when I try & do the following in an update trigger. Basically, before inserting a detail line record, I check for the existence of it's 2 parent header records, & if they don't exist, create them in the appropriate tables. I think I have re-worked the...

Hi All, How does one refer to the value of a field _before_ it is updated. ie you would have code; ... if update(<field>) if ??<syntax for prev. value>?? <> NULL Begin ... ie, I need to execute the remainder of the trigger based on the a) the fact that <field> is being...

Hi All, Below is the syntax of a statement that is giving me a message of &quot;Invalid Column name: 'From ID' at the point marked with an '*'. I have tried lots of ways of delimiting the token for the field 'From ID' (no - I did _not_ design this database, I just have to _work_ with it -...