i want to create a network ready app..
what i mean is there will be one database which all the clients connect to..
when i install the app on the workstations , will it automatically "detect" that it should not create a copy of the db on the client but "connect" to the db on...
i have a password field in a table of mine.
how can i encrypt this one field so that a select statement by any user will not expose the password?
thanks..
i have a function that changes the background colour of a cell based on a paramiter value parsed by a radio button.
This function fires on the 'onClick' event of each radio button.It accepts a parameter .
When i refresh the page I want the function to run by checking all the radio buttons in...
i want to create trigger at the row level to modify a field in each record that is inserted..
i do not have a primary key on my table...
the code that doesnt work is below..
CREATE TRIGGER tr_msisdn_ProcessedRedemption
ON ProcessedRedemption
FOR INSERT
AS
UPDATE ProcessedRedemption
SET msisdn...
i have a field which has multiple choice values which were chosen from a list box .
how can i automatically select these on my update form?
i use dreamweaver mx..
thanks
i have a field in my table that contains varchar data..all the data should begin with 0803465...
i now want to create a triger where i will trim the leading "0" and add 234..
so the number above becomes;
234803465...
can someone show me how to do this?
i need this done on all the...
i need a regular expression that will validate the following:
1)must contain 15 digits..
2)all numbers must begin with 234803
3)
must not be;
234803200
234803201
234803202
234803209
thx
i get people to enter numbers into a particular field..
eg. 2345678..
how can i automatically remove the first digit of what they enter and replace it with +234?
thanks..
i am using bcp to load several text files into a table..
i understand that 4 for several reasons, my text files may not be loaded..
i how can i log these errors into another table if loading fails..
for example , i may want to put the first item in the tx file in another table plus a flag in the...
how can i copy a record with 15 fields from one table to another identical table withot having to do a LONNNGGG insert by passing 15 variables?
any way round this?
i have created a select statement..
select a,b,c from xyz
what i do next will depend on what is in the a field..
how do i get this value into a variable as i want to use it in a CASE Statement?
i have several text files in a directory that all begin with the words batch_registration..
the ending part of the file names is what differs as the date and time is appended to it..
how can i get sql server 2000 to search through this directory and import the files into a temporary table in...
i have a menu and a text box on the same page, in the same form, the menu before the text box..
i want to create a situation whereby, when i choose a certain option in the menu, the text box is disabled and cannot receive focus..
the text box will only be enabled when i select the other...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.