I have a query in which i need to display the part of query output in bold
Example: select 'Previous NAV value for the fund is '+ CONVERT(VARCHAR(50),@prevNav) OUTPUT:Previous NAV value for the fund is 12345 so i need to display the output in BOLD like
Previous NAV value for the fund is 12345 OR
Previous NAV value for the fund is 12345
either the value can be in bold or the text can be in bold
I have some trouble when I build a DNS server. I need use mysql stored procedure work with the bind dlz mysql driver, but failed.
dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=dnsdata ssl=false}
{select domain from domains where domain='$zone$' LIMIT 1}
[code]....
what is wrong with this SQL to create a stored procedure in MySQL please?
Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `CheckStatus`(
IN start_date DATE,
IN end_date DATE)
BEGIN
[code]...
To me the syntax is correct. It complains with error 1327 'Undeclared variable: temp_sales'. What I don't understand is why I would need to declare a temporary table's name as a variable. Am I missing something here?
recently upgraded, now none of my stored procedures work. All return error 1307. what can I do to prevent this from happening?
View 3 Replies View RelatedI have machine that I used to VNC to on my network with Remote Desktop Viewer from my Fedora 12. When I first connected I checked the checkbox that I wanted to store the pw. Now the pw on the other machine has changed but Remote Desktop Viewer does not ask for a new password, it just gives me a black screen, like I am connected but I can't see anything. I'd like to know if anyone knows where this pw data is stored on the system so I can start fresh. I already tried uninstalling Remote Desktop Viewer and installing it again.
View 1 Replies View RelatedI used wget -r to get all the web pages that were linked from index.html. The pages listed in index.html are all chapters. After using wget -r, all the chapters are now in the same folder on my local hard drive. Is there a way to build the chapters in their proper order into a "long"/"full" web page, rather than simply having each chapter as a link/next link on a previous page?
View 9 Replies View Relatedwhat is the best way (i.e standard way that is supported on all browsers and probably as well followed by web crawlers).... to include an html file either locally or externally in another ? Of course , i've done the research and i also know that there are server side includes (php , asp ...you name it) at the moment , i'm using this:
Quote:
<script type="text/javascript" src="path to file/include-file.js"> </script>
however, i've been warned that this method may not show up in some browsers as some tend to ignore this tag and that crawlers like your favorite search engine wouldn't bother reading this. so , what is the best and safest way to do the job? and btw , the reason why i've ousted SSI's from the start is because of among other things:
1) the fact that the included file is static html and because the text is included pretty much everywhere
2) hoping to reduce load time as the code (if successfully recognized) would hopefully be treated like any other embedded external file (e.x like an image) , therefore it would be cached without the need to downloaded it over and over again for each new page on the site.
At work we have a Sybase Adaptiver Server 9.0 database running, it has to stay there for now, and we are developing a web application that will connect to it using PHP.I was already able to make it work using ODBC on Windows and using odbc_connect on PHP.But now we are moving to Ubuntu, and we are trying to get it to work on it.I already have Apache2 and PHP5 up and running.There are two ways (I can think of) we can do this, one is using ODBC and then use "odbc_connect" and the other is making "sybase_connect" work on PHP. Being the latter probably the best one since you wouldn't have ODBC as an intermediary.
Either way, as long as it works I'm happy. ODBC would be fine to meet our requirements for now.I already have ODBC Data Source Administrator but no idea how to create/include/add the Sybase driver.We also tried setting freetds up, but that didn't work either, we might be missing something.
I want to install Sybase ASE 15 on CentOS Linux 5.6 has anyone ever done that.
View 1 Replies View RelatedI'm trying to install Sybase ASE EXpress 15.5 on Ubuntu and am getting the following error message: ./startserver: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory.
View 3 Replies View RelatedI need to reconfigure my php to have Sybase support. However, I am not sure which library to use. I'll try freetds but I am not sure if it will work. I used it before with Microsoft MSSQL.
View 3 Replies View RelatedMy freetds.conf
Code:
# /usr/local/etc/freetds.conf
# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
[Code]...
I had sybase server running on my desktop but after the upgrade it does not seam to start properly. tried to restart the server many times but does not seam to help
The logs are displaying as below
00:00000:00001:2010/11/19 13:53:08.21 server Recovery complete.
00:00000:00010:2010/11/19 13:53:08.26 kernel Initializing Job Scheduler Task
00:00000:00010:2010/11/19 13:53:08.39 kernel Installed Job Scheduler sequencer code version 0.27 - 27 tokens
[Code]....
i get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
View 1 Replies View RelatedI get some trouble setting up good environment in linux.. i have problem regarding connecting php(under linux) to a sybase server(under windows),,, is there anyway connecting this two technologies?..
View 7 Replies View RelatedI'm attempting to get freetds and sybase up and running on my centos server, mainly for nagios - MSSQL checks. I've installed freetds freetds-devel ok but am having issues getting SYBASE installed. I've had a go via cpan but get a failure on the sybase environment variable. I've set it to /etc where the conf file is located as well as trying /urr/lib64 for the tds libs, but no joy. Has anyone had much luck with this on centos?
export SYBASE=/etc
[root@nagios ~]# echo $SYBASE
/etc
cpan DBD::Sybase
CPAN: Storable loaded ok (v2.15)
[Code]...
I want to freely download and install sybase-openclient-11.1.1.3 either source or rpm package sybase-common-11.9.2-3.i386 either source or rpm package Sybase Adaptive Server Enterprise versions 11.9.2 or 11.0.3.3 for Linux. I searched a lot but didn't get it,
View 3 Replies View RelatedSomeone at work has requested if i can find out anything on the above.Been googling around as well as i have only been using Linux for 2 months now.
basically there is a SYBASE ASE installation on the server, which a tomcat based website references.They want the service to stop once a certain row limit is reached in the table.
I know i have to do a count statement on the sybase table from ISQL.But how can i create the action "service website stop" once the count value reaches 4000 ?
just returned to fedora from a stint with xp for development with xp embedded (acutally pretty cool) before i get all cozy with settings and install programs, etc, etc, what is the upgrade procedure for 13? does all of this go for naught, or are settings kept if you upgrade with yum? i hope the answer is what i want it to be!
View 1 Replies View RelatedHave decided to stop using Hylafax and our two serial modems on our server running Clarkconnect 4.1 (RHE4.1)What file will I go to to edit so the program and two devices don't start up?I disconneted the devices and the log file is full of the attempts to get the modems working
View 3 Replies View Relatedi am using linux for couple of years. suddenly i a question arises in my mind. Before loading kernel during booting linux box initrd image loads necessary real mount point, file system, modules etc. but how initrd loads them ?? is there predefined modules list stored in initrd image or something else....what is the background procedure of it
View 1 Replies View RelatedI'm currently running Xubuntu 10.04LTS as my main distro, but would like to also run Fedora 13 on the same machine.Therefore, I'm more so just after a bit of steer of the best plan of attack to achieve this - best procedure to partition the drive (80gb / i686) and install Fedora etc.
View 1 Replies View RelatedWhat to remember when moving content of a file system to another file system ?Is there some kind of procedure for this operation
View 14 Replies View RelatedDecided to try to use my console but it didn't work the way I thought it would. What is the proper procedure to log into my console? I've tried to enter data given to me at http://www.zaphu.com/2008/05/30/ubun...-m4a-playback/ It entered the first line of text but not the unwrapped second line. Another line appeared asking my 'neil' login. Tried to enter my password but typed letters wouldn't enter. What do I do?
View 14 Replies View RelatedHow do I specify a color to a gimp procedure? e.g. gimp-text-layer-set-color I tried '(255 255 255) for white
View 1 Replies View RelatedI'm just figureing out the command line, I am trying to find out how to get to the Internet and browse from the command line, also how can you launch any program you want to use from the command line.thanks for the answers,donald Spauldingexectec@zoho.comI can use the GUI but would like to be faster and better
View 3 Replies View RelatedI'd tried to run HDD bench mark at my Debian Stable called iozone3. It performed I/O actions which took too long. Ctrl+C to terminate process. Everything went as always. It just terminated. Upon completion of program I used laptop for some more time. During shutting down X-Desktop shut down normally. Terminal window was showing command line with lines <Stopping this and that daemon...> but instead of normal black colour background with white text it changed into red background with white text. What does it mean? Is it safe to restart laptop?
View 2 Replies View RelatedJust wonder is it possible to install non .deb package through the standard procedure of make config etc in Debian, or better not even attempt it.I need to use several engineering, mathematics packages, Matlab, Maple and Ansys,I have been told to use Fedora, but I would prefer to use Debian, as all my computers run on Debian and its stability etc is well known, not to mention the nice people in the forum, Bugs, Evil etc, well known icons.
View 6 Replies View RelatedWith Ubuntu i used some software which only had an installation procedure or a package for ubuntu. Program's such as Ailerus or Usenet Resource Downloader. What i would like to is this: Since Ubuntu is Debian-based, is it possible that software, intended for Ubuntu, can also be installed under Debian? Or is there a slight difference in structure between debian and ubuntu that makes it almost impossible to add software, intended for Ubuntu, under Debian?
View 14 Replies View RelatedI was under the impression that if I have any programs not installed by the package manager, they belong in /usr/local rather than /usr. But if I put the executable in /usr/local/bin, and the jar files into /usr/ local /lib, I get runtime errors about being unable to load the Java classes. So I resorted to putting things in /usr/bin and /usr/lib and it worked fine.Is this something that can only be corrected by compiling differently, or am I missing an installation step?
View 2 Replies View Related