Search results for query: *

Here's my scenario. At our main office I have a DFL 210, at Satelite office 1 I have a DSR500N, at Satelite office 2 I have a DSR250N. Sate1 has an IPSec VPN to the main office. Works beautifully. Sate2 has an IPSec VPN to the main office. Works beautifully. Sate1 IP range is 192.168.10.0/24...

I get how server.mappath works. server.mappath(.) gets my current folder server.mappath(\) gets me to the root of the web etc. Here's my problem, I can't be assured that the application itself is at the root of the web. All of the web pages are in the inetpub directory. All of the supporting...

In MS SQL I can define a column as a numeric and still use "null" as a value. Is there a way to do this in Oracle? From what I have seen from the NUMBER data type I have to put a numeric value in and can't use a null To build may have to be the slow laborious task of years. To destroy can...

I'm looking for a sql statement to return the text of a view. I need to make a change to some of the fields in the view, but I can't find the text I used originally to create it. I don't have access to Enterprise Manager or Query analyser so I need a SQL statement that I can run that will...

I have a SQL 2005 server and an Oracle 10 server. I'm trying to set up a Linked Server between them so that I can access some of the ORacle tables in real time from SQL. I've installed the Ora92 client and the 10G_instant client. From the physical box that SQL resides on, I can open SQLPlus...

In the database I have a number of tables with the same column name. for example Employer.FirstName, Staff.FirstName, Person.firstName etc. I'm doing a full outer join and want to rename these without specifying the columns. So it's Select employer.*, staff.*, person.* from employer full...

Seems when I'm working with the ORACLE database and I use a function in my sql statement I loose the first ordinal in my collection. Same SQL statment works with MS SQL. For example. sqlString = "select Max(StudentID) myID from students" rs.Open...

Very new to SQL 2005. I have a 2 databases on the same server. I want to copy 2 tables from one database to the other every night. In 2000 I would have gone to Data Transformation Services, created a local package with the 2 tables I wanted and scheduled it to run every night around midnight...

I'm trying to create a view that takes a table with 4 columns and makes it appear as if it were 8 columns. It's based on a marks spread for a large number of students. The original table layout is: course_code |School_Year | Student_ID | Mark What I need to convert it to is course_code |...

Most of my experience is in VB and Java and have always handle this in my code. I thought that it might be faster to do it right in SQL though. I have a column called Name that contains firstname,middlename, lastname. I need to display them in separate fields in an ASP page. Normally I would...

At some point I should really learn how to use these because they are really handy. I want to add a spell checker to a web application, and have a great little one that will check individual words. Of course only Bill Shatner. Speaks. In. One. Word. Sentences. so I am looking for a regular...

Blah blah blah long story. Here's the gist of it. inserting some stuff into a SQL database, it fails on a number of data sets because some fields are bigger then 8060 characters. When I print the string, the biggest variable is only 1104 characters, so I am guessing that there is some...

A bit of background first. We have an existing FMPro application that is being replaced by a web app. The Web app is using MS SQL 2000 as the database. We've made significant changes to the database structure on the new app compared to the FMPro version. I've been asked to try to import some...

This works on my test box with ACCESS as the DB, but I get a 500 error on it when I move it to the SQL box. It's ASP with Javascript not VBScript. if (!(Session("TeacherID")>> 0)) { teacherID = 0; } sqlString = "select TeacherID, FirstName, LastName, PhoneNumber...

I need to see at a quick glance when something is available. Things are booked out basically on a weekly basis. I'm looking for something that shows when it is available and when it isn't at a quick glance. I was thinking of the Calendar object but I can't find a way to either change the font...

Here's my scenario. I have a PDF form that gets populated dynamically by XFDF files. I create the XFDFs when needed using myFSO.CreateTextFile(myFileName,true) Works great first through. My problem occurs when you try to do this multiple times. We get a Microsoft JScript runtime error...

I've been asked to add some more information to a web page. The original select statement works fine, my problem is in the change that I have to make. Basically I think that I need to do a select based on the results of the first select. Here's the statement. SELECT employer.name...

I've been tasked with trying to find an inventory control system. Currently we have 4500 to 5000 systems in service with a vast variance of technology (DEC Alpha Servers, DEC Vax 2000 Workstations, Compaq 486 DX 33's, Pentium Pro, PII, PIII, P4, Mac Performas, Mac G3s, G4s, G5s, Dot matrix...

I have an fdf with the data that I need. I have a PDF with the right forms for the FDF file. I have a function called doImport() that says this.importAnFDF("myfdfFile.fdf") Now...how do I get this function to run when the document opens? "Every day is like a precious gift, you...

I'm really stumped by this now. I don't have any loops, I've commented out everything else so I know that I am looking at the only code that is running and it still happens. When I create a new entry in the database, it creates 2 identicle entries. It doesn't matter if I use AddNew() or if I...