Search results for query: *

Hi, i have a database table column whose content looks like 'abc-1-a-2-01'. i know i can use split(column_name, '-'). this gives you 5 rows of data like abc 1 a 2 01 however, i like to split this into 5 separate columns like abc 1 a 2 01 any help would be greatly appreciated. thanks.

Hi, i have an access 2003 database with some tables. i'm trying to get a list of tables in the database. the code i'm using is: Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") dbfile = "c:\a\fleet\fleet\fleet2.mdb"...

hi. i have a page that submits the data and goes to a 2nd page (asp) using a submit button. i would like to print the screen AND submit the form. there's a javascript snippet that checks the data before submit. is there any code that can be placed in java script snippet to print the screen...

Hi. I have this page that is supposed to display a jpg image from a db on an intranet page (which works fine). I have been asked to let a user to save this jpg image save on his/her local machine when the image is displayed on the page. I used a piece of code that tsuji had posted a while back...

Hi. i have two tables a and b. table a: id name 1 john 2 jane 3 jack table a: id name 1 john 2 jane 3 jack 5 jim 6 mike 7 tom i want to see only 1, 2 and 3 to show up on the resut. i'm using join. but it lists all 7 rows no matter what i use. thanks.

Hi. i am trying to write a script that scheduled to run every week and delete old archive files. the files are in a folder under c:\arch\. i have a vbscript that examines the modify date of the file. but i need to look through all the files in that folder and delete anything that is older...

Hi. i have an intranet page that has several functions. one of them (planning on having) a page that checks a server to see if it's up or down. i've been trying several things to ping or read a text file on the server to see if it's up or down. but, i'm getting errors. is there any way to ping...

hi. i'm in the process of making some changes to a number of tables in a database. is there a way to find if a certain column (col_name) exists in any table in the database? thanks again.

Hi. i have a situation where i would need to delete items from the registry. is there anyway to use a vbscript or something like that to delete an item from windows registry in win-xp? like: specifying a string locating the registry item that contain the string delete the registry item thanks

hi, i have to make sure that pc's always have a certain website as home page. can this be done automatically using vbscript? thanks

hi. i have an access 2007 database that i have split into back end and front end. i want to create two different forms in 2 different front ends for 2 users. each user will see only a portion of a table in their forms. how would i do this, please? thanks.

Hi. i have several ms access 2007 databases currently used by many users. i like to have a vbs to list all the object in each database. i had an old script that listed objects from access 97. but, it's not working on access 2007. i modified it to access the sys objects, but it says no...

Hi. i have a form. that has a pull-down list of codes. these codes and descriptions are in a table. when i select a code, i like to populate a box that has the corresponding description for that code. how can i do this please? thanks much.

hi. i have a desktop machine that's running win-xp sp3. the integrated sound card went bad and the motherboard was replaced. all functions work except that it will not connect to sudeenlink broadband network that previously did. any ideas what would cause this? do i need to do away with the...

hi. i have a page where you enter last name and first name and the page gets the data from oracle table and displays any last name that matches using a few first letters of the name. however, if they leave the first name blank, it still fetches all the matches based on last name. now, here's the...

hi. i have this href within a repeater control: <td> <a id="Anchor1" href="Page.aspx?uid=?????????" runat="server"> </a> </td> <td><%#Container.DataItem("user_id")%></td> <td><%#Container.DataItem("last_name")%></td> <td><%#Container.DataItem("first_name")%></td>...

Hi. i have developed an app using vb.net and it seems that my first try at this is going ok. the app retrieves some records from an oracle database and the "repeater" control puts them in a table with tr and td tags. however, i want to be able to examine each records in the recordset and...

hi. i'm getting an error when connecting to sql server db but not when connecting to access db. here's my code: <%@ Import Namespace=&quot;System.Data.OleDb&quot; %> <script runat="server"> sub Page_Load Dim dbconn, sql, dbcomm, dbread dbconn =...

i'm getting this error when i try to connect to my database: any ideas? here's the connection string: strCon = "Server=A20ootb05l01457\A032299;Database=master;Trusted_Connection=True;" Set objConn = WScript.CreateObject("ADODB.Connection") objConn.Open strCon the error is: Error: [Microsoft]...

hi. i have obtained a .dmp file from a production database. i have been asked to delete the test database and make the test database look like the production database. so, i'm guessing a reload/restore of some sort is required. is there any way somone can guide me in the right direction as to...