Below is the structure of the tables as it is now. Is it good design to have two table attributes/fields use the same relationship?
resOwner and resVendor both refer to orgID it just depends on the orgType. I thought of breaking the Organization table into an Owner and Vendor tables but then...
I have installed Timecard Management Application Template on my server running Windows SharePoint Services (WSS) 3.0 and it will not save the time spent on a task. I can punch in / punch out but when I look at My Hours Today nothing shows up. Any suggestions?
-chris...
SELECT permission denied on object 'tblHardware', database 'hec_inventory', schema 'dbo'.
SQL Statement: "SELECT * FROM tblHardware"
Here is my problem...
I can connect to the DB just fine using a login i created. I have the server setup in SQL & Windows authentication mode. I added the...
My friends computer wouldn't turn on and I figured it was the power supply. I got a new one that has more watts but when I installed it, the lights will come on but the computer will not boot. I justs shuts off after a few seconds. Do i have to reset the bios or something?
I'm a little confused about the layout of an array returned by getrows().
It is my understanding that when you create a multidimensional array, myArray(10,3) the first number, 10, is the rows and the second, 3, is the columns.
However, when I pulled the data with getrows, this seems to be...
I am trying to convert string input to an integer using the cint() function. I am running into a problem when I try to convert the string "0" to get integer 0. Any solutions for this?
Thanks!
I have a computer with XP Pro and IIS 5.1 but cannot get the write permissions to work. In the IIS manager, I have set the permissions to Read and Write but I am still getting an error. If I try to use Windows Explorer to set the permssion, there is no Security tab to check if IUSR_COMPUTERNAME...
Hi, Here is my problem:
I have a main form with sub forms. On the sub form I have a text field that equals =Sum(ProjectHours). I want to take that value and assign it to a text field on the main form.
This is the code that was working at home but at work it does not.
Private Sub...
My system is hosed and I need to import some .reg files from the command console. I tried from the recovery console but it will not let me run any program (regedit.exe) other than the commands it supports. I thought about booting from a WIN98 disk but then it would not read from my NTFS drive...
I posted this in SQL programming but they thought I might haver better luck here. Also, the program works fine 90% of the time =). only every so often do I get this error...
I am reading from multiple CSV files that are exported from a program we use. Every once in a while I get this message...
Hi, this one is giving me a big headache.
I am reading from multiple CSV files that are exported from a program we use. Every once in a while I get this message and my program fails. Has anyone gotten this message before?
DB fields: title,Dauthor,collection,call,item#
Below is the error &...
I have csv files that I use for my database. They all have the same field names (FName, LName, Address) but are created 2 or more times a month. I end up with files named 12Jun03.txt, 17Jun03.txt, and 23Jun03.txt.
I can use each file name just like table name. Is there a way to write an SQL...
Hi, I am a ColdFusion newbie.
I am trying to use CF to process my email form and am having trouble with my error checking. Previously I had written a javascript function to check for required info and then submit the form if all info was present using the form.submit() method. This would then...
I want to be able to have one text field showing but if the user needs to use another, they'll be able to click on a button and a second one appear and so on. Is this possible without refreshing?
I'm trying to get a list of text values from a user and I want to be able to let them add as many text fields as they need.
Ex. txtField1 holds Green so the user click on a button to add another field and then txtField2 appears. And so on.
Is there a way to do this without having to reload...
I'm using a Access to store the dates I need to compare and I want to delete a record that has a creation date prior to the current date.
What is the SQL statement that will do this? I tried to use a string like the one below but it didn't work. If I use > it works but deletes everything...
newb quesion:
Can someone describe to me what the difference between Crossover, patch, jump cables? If I get the wrong kind, will my network not work.
thanks!
I read out the data from the db and print it to the screen.
I use this code to do that for another Text field and it works.
do while NOT rs3.EOF
if rs3("Q7t") <> "N/A" then
response.write rs3("Q7t")
rs3.MoveNext
loop
For the Memo field, I had to save the...
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.