I have a table
column1...column2.....column3
column1 is an int
column2 is an int
I want to store column1/column2 in column3 and have it update each time column(1 or 2) updates.
What is the best way to do this? I was thinking a trigger and a stored proc? Is there any way to store that...
I am not very familiar with java. I'm trying to load test an oracle database with jmeter though.
I keep getting an error that states "no suitable driver exists"
I have downloaded ojdbc14.jar from oracles website. That doesn't seem to work.
I'm a little confused. What exactly do I need to...
I have two tables, when I join the data comes back like so...
field1, field2, field3, type1
field1, field2, field3, type2
field1, field2, field3, type3
Is it possible to make the data come back like so
field1, field2, field3, type1
type2
type3
I have a script set up with the transaction logs from a previous day. I converted that to a .sql script and ran on query analyzer, to test out performance.
The only thing is, it is not apples to apples because I have only 1 connection open to the database.
Is there a way to script out...
I have never used Visual Basic 6.0 before. I have used vbscript before.
How do I concatanate a variable into a string in Visual Basic 6.0?
For example...
I have a fuction call where I pass in the path and an image name, The path is always the same, but the image is always a variable.
1...
I have a web server that all the sudden DLLHOST.EXE starts eating up all the memory on the server.
Anybody have any ideas what would cause DLLHOST.EXE to all the sudden start eating up memory? Also, anybody have any ideas on how I could pinpoint the application that is causing the problem...
Any body familiar with products that load test citrix environments?
So far I've looked at CitraTest and LoadRunner.
I've heard people don't get the best results with LoadRunner, as it does everything through the protocol, while CitraTest emulates a real user using the application.
Anyways...
I have a script that opens up some browsers, when i'm done I need to close all the broswers. ie.quit only closes the initial broswer I opened. Not all the broswers on my screen.
Is there a way to kill iexplore or close all ie windows running?
I have a vb app I am trying to stress test. I fire it off with a batch file.
When the vb application ends, a message box is displayed, in order to end the application the message box must be pressed.
Is there a way I can make that button be depressed, either through a seperate vb app. Maybe...
Hi, currently I have a batch file to launch a vb application, the app takes a couple parameters, so my batch file looks like the following...
@ECHO OFF
C:
CD\a directory
someapp.exe param1 "param 2"
My problem is, when the app finishes executing, a message box...
I have a table that looks like this...
SomeTable
userID(int)
somedate(datetime)
somethingelse(varchar)
There is no unique field currently. I want to make the first two columns together the primary key(userID, somedate).
When I do this I get an error for primary contraint.
I relize that...
I have one checkbox in a form
<input type='checkbox' name='sched' id='sched' value='60'>
my validate function is as follows
function validate() {
var size = form_1.sched.length;
//alert(size)
var returnval = false
for (i = 0; i < size; i++) {
if (form_1.sched[i].checked) {
returnval...
I'm writing a web page to do some scheduling, I have a table
Table1
id
user
beg_date
end_date
The user specifies a begin date and end date to schedule, I do two queries like the following for each date specified....
SELECT * Table1
WHERE (CONVERT(datetime, userspecified date) BETWEEN beg_date...
I’m building a little scheduling web page, where the user can check out a component for a certain time period. The web page will allow them to select a component, a begin time a begin hour an end time and an end hour. The only stipulation is that the same componenet cannot be checked out for...
I have the following query...
It makes a join between 5 tables to pull out some info, name, email, ect.
In my where clause I have some info like
Where (table3.status IN (15,16) and (Table4.otherstatus IN (2,3,5,11)
Here's my question.
I need to pull another piece of data from another...
aflag = "YES"
sLSQL = "Select Min(afield) as Newfield From atable where anotherfield is null"
Set oLKRS = oLKCon.Execute(sLSQL)
this = oLKRS.Fields("NewField").Value
Set oLKRS = nothing
if tid = "" then
aflag = "NO"
end if
If my query brings...
I need to declare an array in vbscript...
The number of elements in an array will be the value of a recordset that comes back...
Here's my code. It doesn't like the last line. Any hints?
dim count
gettypecount="select count(*) from Sometable"
set...
openit('some.asp?atime='+escape(atime)'atime2='+escape(atime2),1000,550)
trying to pass the following URL and other values to a function..
pretty new to Javascript, I get a missing ) error?
Can you have variables inside your javascript objects. For example, would the following code work?
Let's say I have a group of checkboxes named, check1, check2, check3, ect. Up to 20...
Can I do the following...
for(var i=0; i<=20; i++){
if...
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.