1,073 Posted Topics

Member Avatar for preeti anand

Hello, You are looking for the cast and convert commands. For example: [CODE]SELECT TextID AS ID FROM W1 UNION SELECT CAST(NumericID As VARCHAR(20)) AS ID FROM W2 Or, if you like CONVERT(): CONVERT(VARCHAR(20), NumericID) [/CODE]

Member Avatar for rch1231
0
70
Member Avatar for ashnet16

Hello, You will probably have to export the Oracle DB to a file (CSV is probably best) and import it into MySQL. I don't think there is an option for importing directly from Oracle but yes it can be done.

Member Avatar for rch1231
0
47
Member Avatar for frogboy77

Hello, It depends on the model and year. Check the toshiba support site for your model and see if they put copies of the install cd's on the drive or if there is a separate recovery or restore partition on the hard drive.

Member Avatar for rch1231
0
82
Member Avatar for Leo G

Hello, Two things: You can use Partition Magic to re-size the partition on the drive to 250 GB. Yes you can plug the laptop SATA into your desktop I do it all of the time. The power and cable pin-outs are the same.

Member Avatar for Leo G
0
280
Member Avatar for andywyndom

I see a couple of problems with the way you set up your data for the database. In several cases the end date is prior to the start date. The table assumes that the start and end date are not null and in many applications they can be, or at …

Member Avatar for andywyndom
0
199
Member Avatar for jryans10

Hello, First thing I can think of to check would be do you have a fixed IP from AOL in other words do people access your computers from the web. If so you need to be prepared to change your IP address when you get a new one from your …

Member Avatar for rubberman
0
114
Member Avatar for Octet

Hello, I would try running nmap against your server and take a look at this site for some suggestions on security settings to use. [URL="http://www.tldp.org/HOWTO/Security-HOWTO/"]http://www.tldp.org/HOWTO/Security-HOWTO/[/URL]

Member Avatar for rubberman
0
244
Member Avatar for socheata

Here is a subnet mask table that tells how many IP addresses are in a subnet based on the mask used: [CODE]ID # Bits Number Hosts Usable Hosts Netmask Note 6 /6 67108864 67108862 252.0.0.0 7 /7 33554432 33554430 254.0.0.0 8 /8 16777216 16777214 255.0.0.0 Class A Network 9 /9 …

Member Avatar for JorgeM
0
158
Member Avatar for newbie26

Hello, Depends on how you are trying to start mysql through putty. Normally I run the following command as root or with sudo: service mysqld start or you can run mysqladmin start -u root -ppassword

Member Avatar for rch1231
0
74
Member Avatar for PyroPlasm

This might be more efficient. Te find command will do what you want all in one line. [CODE]find . -type f -mtime -1 -exec ls -la {} \; [/CODE] This command looks for files in the current (.) directory and then runs the ls -la command using the file name …

Member Avatar for shibblez
0
148
Member Avatar for me!

Hello, You could try increasing the number of outgoing queues that qmail is using. By default it is normally 20 remote connections however I run mine at 60 to accommodate one of my clients running a mail list server. Reference the following qmail page for more information: [URL="http://www.lifewithqmail.org/lwq.html#config-files"]http://www.lifewithqmail.org/lwq.html#config-files[/URL]

Member Avatar for me!
0
207
Member Avatar for vinodvinu

Hello, Yes. If the processor gets to hot the PC should turn off rather than fry the CPU. Without the fan the CPU will cook and have to be replaced within 60 seconds, less time on newer processors.

Member Avatar for vinodvinu
0
96
Member Avatar for clerisy

The nl2br() function adds the <br> tag if it finds the carriage return (\n) in the text. If you text is long and at many places carriage return is present, even then the nl2br() tag will replace all the occurrence of the carriage return with <br> tag.

Member Avatar for diafol
0
84
Member Avatar for ktkett

Hello, Go in to device manager and un-install the network devices with the Exclamation Point. Shutdown and Power the computer off completely. Wait 30 seconds. Power the computer back on and the system should reinstall the drivers for the devices that have been un-installed. If it cannot install the driver …

Member Avatar for rch1231
0
218
Member Avatar for R3d90

Hello, If you check on the gateway site for listings of beep codes for the BIOS. or here is a site that list the codes for various BIOS manufacturers: [URL="http://www.5starsupport.com/info/beep_codes.htm"]http://www.5starsupport.com/info/beep_codes.htm[/URL]

Member Avatar for rch1231
0
239
Member Avatar for magikman

Hello, have your tried moving the two lines to print the totals [CODE]# print "Total space: $totalSpace\n"; # print "Total used: $totalUsed\n";[/CODE] up above the calculation so you can make sure neither one came out 0. And if it is a percent shouldn't you also multiply by 100?

Member Avatar for d5e5
0
476
Member Avatar for jaso24

Hello, You can pick up a USB external housing for aroung $40 and put a CDROM in it then boot from the USB-CDROM. For network boot you have to set up a system with a tftp server, dhcp server, and pxelinux (part of syslinux) or look into Microsoft RIS. I …

Member Avatar for Abdulwahab786
0
580
Member Avatar for teedoff

Well this may help. I found an Excel spread sheet on the web that has makes and models from 1990 to 2011 for just about every make and I can think of. There were several for sale but this one was free and you could import it quickly to mysql. …

Member Avatar for rch1231
0
2K
Member Avatar for billmudry

Hello, I am not sure exactly what fields you are trying to post to the second file but here is the way i normally do what you are attempting. Step 1. Figure out the record ID or something unique you can use to select the records needed for your insert. …

Member Avatar for urtrivedi
1
2K
Member Avatar for Onlineshade

If the system is still running you can get to an alternate login screen by using <CTRL> <ALT> <F2> or F3 F4 F5 etc.

Member Avatar for nicentral
0
148
Member Avatar for Pepdeal

Hello, Have you tried right clicking on the txt file and selecting [I]Open With[/I] and then selecting [I]Microsoft Word[/I]? If it is not in the liet then add it using the option at the bottom...

Member Avatar for caperjack
0
1K
Member Avatar for s.w.a

I think the part you are missing is that during the initial configuration of the Public server the addresses of the Protected servers are provided in a configuration file. Without the configuration file the Public server does not know where to redirect the requests.

Member Avatar for jonywags
0
161
Member Avatar for Karlwakim

Most CPU's have a maximum temperature that they can operate at before they fry. Usually it is around 80 to 90 degrees Celsius which is 10 to 20 degrees below the boiling point of water (100 degrees Celsius). So the answer is it would not work,

Member Avatar for caperjack
0
168
Member Avatar for mus123

Hello, Look into Gallery2 which is a PHP and MySQL based photo gallery application that is easy to install and configure. Creates the thumbnails for you and lets you create albums as needed as well as having public and secure login options.

Member Avatar for mus123
0
84
Member Avatar for jmrpjb

hello, The first thing I can see looking at the report is that you have two different speed and size chips in the system. Based on what it says you have one 256MB PC-3200 200MHz chip and one 1024MB PC-2100 133MHz chip. The system will slow down to the speed …

Member Avatar for jmrpjb
0
171
Member Avatar for g3nX

Have you tried to get to the port locally inside you network to make sure it is available. You can use telnet to connect to a port and see if it is working: telnet 192.168.1.3:25 Would connect you to port 25 on the local system at 192.168.1.3.

Member Avatar for g3nX
0
333
Member Avatar for smiley4080

In order to help I would like a little more information. What is the purpose of the database or report you are trying to run? Is it to verify supervision, plan a schedule, or what? If you are trying to plan a schedule then I think you need to know …

Member Avatar for ChrisPadgham
0
289
Member Avatar for parulchahar@yah

Hello, We would probably need to see your code to be able to give you an idea of why you are getting the error.

Member Avatar for rch1231
0
57
Member Avatar for serdas

Your problem is coming from the fact that MySQL requires a user be defined for every connection to the databases. It can also restrict what each user coming from specific IP addresses can access. If you look at the mysql database and the users table (you have to be the …

Member Avatar for manojsamtani
0
228
Member Avatar for SCass2010

Hello, Try running fdisk and get a list of what drives and partitions the system sees connected. [CODE]fdisk -l [/CODE]

Member Avatar for SCass2010
0
160
Member Avatar for pack22

Hello, A few things to check. Have you moved the router to a new location? It should be kept high off the floor because the high frequency signal can interfere with its self if close to a reflective surface (concrete floor or FireWall). Is the modem hot? Usually when they …

Member Avatar for pack22
0
163
Member Avatar for jatashankar

Hello, If I am reading your post correctly the product field already exists and New_Oppourtunities is the new field you want to add. Your problem is the AS entry. AS is used to rename an output column heading when a query is run against the table and is not an …

Member Avatar for rch1231
0
713
Member Avatar for jmrpjb

Hello, Your problem is that the file you are trying to attach to the email is too large. Most email servers limit the size of an attachment to less than 10MB.

Member Avatar for gerbil
0
366
Member Avatar for libathos

Hello, No you don;t have to have a separate procedure for each and (sorry hericles) I can think of a hundred reasons to insert into multiple tables from a single record. a simple example would be adding an item to inventory that is a part of another item and you …

Member Avatar for libathos
0
380
Member Avatar for Stickie

Hello, Looking at the order of the output I would be willing to bet that the variable type for Aantal_Duiven is varchar or char and is string based and not Integer of Float which are numerically based. What you are seeing is a sort based on alphanumeric characters instead of …

Member Avatar for Stickie
0
407
Member Avatar for CMaker3

Hello, Yes you can have them both at the same time but the trick is to have them on different subnets and only have one gateway. The gateway address is used to designate what ip address you use to get to the internet. Different subnets would be say one network …

Member Avatar for CMaker3
0
447
Member Avatar for wisedave

Well as far as I know you have got three choices. You can either record a .WAV file and attach it, use the Voice Memo in your smart phone to create the memo and attach it or turn on voice recognition and let them dictate to the computer and have …

Member Avatar for rch1231
0
220
Member Avatar for dozierc

Your sed line is saying to substitute the word [I]new[/I] for the word [I]old[/I] globally in the filename.old file and output to the original file name. You would need something like this: [CODE] sed s/\/opt\/dragon\/bin\/runit/cd\ \/opt\/dragon\/bin\ \;\ \/opt\/dragon\/bin\/runit/g[/CODE] But this would do the same thing: [CODE] sed s/\/opt\/dragon\/bin\/runit/cd\ \/opt\/dragon\/bin\ \;\ …

Member Avatar for rch1231
0
144
Member Avatar for Zevs

It means that the user you are logged in as does not have administrator privileges on the computer. In order to make changes to the OS you have to be a member of the administrators group or logged in as administrator.

Member Avatar for jholland1964
0
114
Member Avatar for freebird6797

Hello, Try opening a command line window (run CMD) to get a dos prompt then type: mysql You should get a mysql shell prompt that your can run queries from like [CODE]select * from mydatabase; [/CODE]

Member Avatar for rch1231
0
89
Member Avatar for princedamson

Remove the gateway IP address from the card that is not using DHCP. There can only be one gateway to the internet. Here is the data from my ipconfig: [CODE] Windows IP Configuration Wireless LAN adapter Wireless Network Connection 2: Connection-specific DNS Suffix . : Link-local IPv6 Address . . …

Member Avatar for talktoade
0
176
Member Avatar for kingofnothing

Add the following to the beginning of your text file: [CODE]USE Database ;[/CODE] Where Database is the name of the database you want to create the table in.

Member Avatar for kingofnothing
0
217
Member Avatar for XBryanFuryX

Based on your post you are trying to boot an image of Windows XP. Just burn the ISO to a disk using the "Burn Image to Disk" and not with the "Make it boot-able" option from Nero. Nero is adding DR DOS to the disk to make it boot-able and …

Member Avatar for rch1231
0
152
Member Avatar for reversefiction

Hello, I would go with the AMD over the Intel cheaper and more bang for your buck. and for virtual installations look in to Oracle Virtual Box. Runs on Linux or Windows and will run Linux or windows as virtual OS.

Member Avatar for reversefiction
0
218
Member Avatar for lena1990

Hello, My first question is where is the file you are trying to open? By that I mean is it on a CD or something that you cannot write to. When access opens a DB it creates a <dbname>.ldb file in the same directory. In your case the file would …

Member Avatar for rch1231
0
119
Member Avatar for snefmoo

Hello, Nagios is a free Linux based monitoring tool that will monitor uptime, disk space and services on Windows or Linux. The company I work for uses PAMonitor to monitor various Windows systems and services and Nagios for Linux and Solaris. [URL="http://www.nagios.org/"]http://www.nagios.org/[/URL] [URL="http://www.poweradmin.com/ServerMonitor/"]http://www.poweradmin.com/ServerMonitor/[/URL]

Member Avatar for rch1231
0
119
Member Avatar for BTCG07

I have come accross this a couple of times. What you need are the chipset drivers for the AMD motherboarde. Once you have those the others will be useable. See if there is a listed chipset in the windows 7 drivers list and go to the homepage for the Mother …

Member Avatar for hispeedprc
0
353
Member Avatar for Ritesh_4

Hello, I found a Microsoft command line tool called WMIC which can disable or enable the NIC. 1. Get a list of NICs and their index numbers with the command: [CODE]wmic nic get name, index [/CODE] 2. Find the index number of the device you wish to disable. 3. Using …

Member Avatar for Ritesh_4
0
356
Member Avatar for jayreis

Hello, You would need either an external USB CD-ROM drive or a bootable USB drive with something like UBCD4Win or hirens boot disk that has a windows password change Utility on it.

Member Avatar for jayreis
0
144
Member Avatar for Zwiebi

Hello, What you are trying to do is really what unix shells were designed for. Try this: [CODE]for x in `/bin/ls /home` do find /home/$x \! -user $x -exec echo "{}" is not owned by $x \; done [/CODE] This executes the command /bin/ls /home and puts the results in …

Member Avatar for Zwiebi
0
233

The End.