Hi. I hoping to get some help incorporating an SSIS package (either via SQL or file) into a job with multiple steps. The SSIS package would take place somewhere in the middle of the steps. I'm running SQL 2005 on a Windows 2003 Server OS. The SSIS package drops an existing table in the database...
I have absolutely no clue where to start and know virtually nothing about CGI, but wasn't sure what forum to post my question in. I'm wanting to create a search engine for our web site, but have never had one before and am not sure what would be the best approach. Does anyone have any...
I've read everyone's suggestions and will try all of them, however I will have to tweak the dreamweaver example somehow to make sure it will expand and contract and I need it to. I'll let everyone know what i end up with and my final results page. (The end result should look similiar to the...
The look I am striving for in redesigning the look of our entire site, can be found at: http://www.co.rock-island.il.us/rico1g/ This page was created as a layout tool only using Photoshop and ImageReady.
The actual page (as coded thusfar) can be found at...
Excluding the slight difference in the background image of the header, you can check out:
http://www.co.rock-island.il.us/Rico2/index.html
That's the look I'm trying to achieve. while:
http://www.co.rock-island.il.us/Rico/index.asp
is what I have at the moment.
Also, if you want to take a...
I'm having this problem with the "header" on my web page. I just started working with CSS and SSI this week and thought I had the hang of things until now. Here's the deal...
In my Index.asp, I have an SSI:
<!--#include virtual="/TEST/Rico3/Header.asp"-->
The code for my...
I have a multi-page form using asp and on my second page, (get_main_categories.asp) on submit, I run this javascript validation code against a bunch of checkboxes and it isn't working. It worked fine on win98 with pws, but then I incorporated it with my page layout; all formatted and everything...
I'm getting the following error: I need to insert a record into one table, grab the autonumber key (Register_ID)and insert multiple records into another table with the key. Does anyone know why I'm getting this error and how I can correct it?
ADODB.Connection error '800a0bb9'
The...
The Register_ID is the key (autonumber field) to another table (WebRegister) within the same access db. All of the basic user data from the form is inserted into this table with the first recordset. After I insert (add) the record to the WebRegister table, I grab the Register_ID and store it...
Ok, I'm narrowing down the problem. I've commented out this code:
'for each objItem in request.Form()
' if left(objItem,5)="cksub" and request.Form(objItem) <> "" then
' ComRs.AddNew
' ComRs("Register_ID") = strRegisterID
' ComRs("SubCategory") =...
To answer your question vbkris, the checkboxes on the first page are hardcoded (even though I could've created them dynamically). It's the checkboxes on the 2nd page that generate the checkboxes dynamically, via my access db (it just made more sense and used less code).
shaddow - I tried this...
I've done some rearranging of my code and have that particular problem solved. However, I have two other issues related to this project. If you could look at them, that would be great (I'll refer to thm at the bottom of this posting) - In the meantime, here is my solution to this problem...
To clarify, "....I need to figure out is how to loop thru my checkbox array and insert a record for each value with the same Register ID."
Based on the above scenario, the registerID which I received from my first recordset (for this form submission)is equal to 10. Each elecment in...
First of all, I've solved issue number 1: My first recordset was defined as SupRs. So, when it got to the following code, it came up with a type mismatch error:
'Retrieve the Registration Identification Number
strRegisterID = Rs("Register_ID")
The line above should've been...
Prior to trying your idea, which I'll do after I solve this problem.....
In my first post, I show a line where I get the Register_ID from the table and assign it to the variable strRegisterID. When I try doing a response.write of the variable, I get this error:
Microsoft VBScript runtime...
I'm not validating (that code is already done) With issue number one, I'm just debugging, so I'm writing info to my page rather than coding it on the page, to make sure I'm getting the information I need. The code I'm hoping to replace it with is actually issue two. So, issue one would be...
Prior to testing my code and actually updating the db, I'm trying to write it to the page to make sure their isn't a loop or massive problem with my code.
The second issue that I stated (my loop to actually add the info to the database will replace the code in issue one) - sounds redundant, but...
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.