Search results for query: *

Hi people. I'd like to set a check constraint on a table that says, if the count of ON bit fields for a particular ID is greater than one then don't allow the update/insert. i.e. SELECT Count(ID) FROM tableName WHERE bitField = 1 GROUP BY ID HAVING COUNT(*) > 1 should be zero or null I'm...

Hi Folks. I'm sure one of you out there must have come across this problem. I'd like to put the names of all active databases in a cursor so I can loop through them. They have to be up and running though - not in single-user mode for example - as the query I'm using falls over when trying to...

Can anyone help please. Someone out there must already have a solution. I regularly have to copy stored procedures from a source development database to many other databases. I do this by copying the CREATE PROCEDURE code and pasting it to all the other databases. What I would like is a way...

Hi. I've written a function which sets a variable (ParentWin) equal to the current window's opener. If an opener does'nt exist it opens a new window and sets the ParentWin as that. This gaurantees there's another open window that can referenced. I've written a 2nd function, which takes two...

Hi people. Can anyone tell me how I can convert a string into Hexadecimal values. e.g 'BaD' to '%42%61%44'. I've tried Hex() which seems to only work with numerics and ASCW(), which converts to decimal but can't seem to find anthing to do this. The reason I'm trying to do this is I'm building...

Hello. I'd like to constrain a table column to be either 11 numeric digits long or null. Though it's not strictly correct I can make the column Int to force numeric values but it's specifying Length within the constraint I'm having problems with. I've spent a while trying to achieve this but...

Hello. I have a query which joins tables from 2 databases. If this query returns any records I'd like to send an email notification. I first thought of using a DTS package but it only seems to be possible to execute a task against one connection and therefore one database at a time. I also...

Hello. I'm trying to create a constraint on a table which prevents null values in colummn B when the column A bit field is '1'. It seems that a contraint is the ideal way and I've tried the following. Alter Table TableName Add Contraint CN_ContraintName Check (B IS NOT NULL where A = 1)...

Hello. I'm trying to set-up transactional replication between 2 servers. I've followed the wizard to replicate the table, am warned only tables with primary keys can be published in transactional replication, only to to find the 'specify articles' menu does not allow selection of tables with...

Hello, I'd like to display an image or message to let visitors know a page is opening. I've got some Javascript which in theory hides a layer once the page ready state is completed. However, even using Response.Flush (with Buffer = TRUE) the content is all released in one go, so the layer...

Hello. I have a folder containing PDF's which I only want those who have a logged-in session variable set to access. It seems there should be some way of tying the session variable and access to this folder together but I can't find anything on the internet. The reason this idea came to me is...

Hello folks. I'm trying to make a button in one frame which when clicked submits the contents of forms in 2 other frames. I've got so far using a function: function Posty() { parent.CentreFrame.form1.submit(); parent.RightFrame.form1.submit(); } and calling it in a form by <form...

I have an table of terms and would like to find the the nearest match to searched terms. For example, if the search term is 'Holand' the query returns 'Holland' as the nearest matching term in the table. The idea being to allow for mistypes, mispellings and plurals. I can think of one way of...

This is a really difficult one... I've got lot of data with hierachical relationships. The only way of ascertaining how many terms above or below an entry is running a query against a joined table. eg. Select Table_Main.Main, Table_Higher.Higher from Table_Main Inner Join Table_Higher on...

I'm sure what I'm trying to do is'nt that unusual but I can't find an answer anywhere. All I want to do is find the records in one table without exact matches in another table. To put it another way records where Table1.Column1 <> Table2.Column1 AND Table1.Column2 <> Table2.Column2. I need to...