Any Programmers, out there ...
Topic started by Raghu (@ 217.158.120.226) on Wed Jul 24 11:13:51 .
All times in EST +10:30 for IST.
Hello all;
I am an TSQL/VB6 programmer, I work as a database developer, I would like to know few programmers, so that we can help each others out, I would be much obliged & grateful,if anyone would help me.
thanks
q)I have the following table in SQL server 7
Create table employee
( empid int not null,
empname char(25),
empadd1 char(50),
......
)
The field empname has the following values
Jhon smith
Jhon crawley
Jhon blah blah
I want to replace the string "jhon" (just that bit) with John, without changing the rest of the characters in empname field.
replace function like
select replace ('empname','Jhon',John')
does not work as it replaces the whole string in the field.
should I decalare empname as variable of character type or use textptr to do this ?
many thanks
Responses:
- From: Mohamed Moosa (@ cache8-2.ruh.isu.net.sa)
on: Tue Aug 6 07:52:43
Dear Raghu,
I don't know much about SQL. However I studied Oracle, but forget it because of long time no touch. But I can give you the method to do, that can help...
in FoxPro the solution is : REPLACE empname with 'John'+RIGHT(empname,LEN(empname)-4) for LOWER(LEFT(empname,4))='jhon'
{{{ the theme is to split the name with functions and concatenate them again while replacing}}}
If you want more expanation, just mail me...
I am learning COM in VB6 anybody wanna help, please help me with tips...
- From: Helper (@ j22.jrc32.jaring.my)
on: Tue Aug 6 12:25:11
Informix has substring function. I am sure Oracle also should have similar function
update employee set empname[1,4]="John"
where empname[1,4]="Jhon"
will work in Informix
- From: Raghu (@ 217.158.120.226)
on: Wed Aug 7 05:20:56
Thanks guys!
- From: blurblob (@ fcomet.singnet.com.sg)
on: Tue Sep 10 02:12:20
Hi greetings to all IT experts. I need some help on what is cold fusion. Can any of you explain what is this application or how can one get training on this application. Is there any useful sites you can recommend? Thanks in advance for yr help/asistance.
- From: Raghu (@ 217.158.120.226)
on: Tue Sep 10 06:13:00
blurblob (@ fcomet.singnet.com.sg) ;
here is the explanation of cold fusion ;
ColdFusion, developed by Allaire which has recently merged with Macromedia, is a popular and sophisticated set of products for building Web sites and serving pages to users. With ColdFusion, a company can build a content database using input templates and combine these with application programs to create a Web site in which pages are developed dynamically as they are served. ColdFusion consists of ColdFusion Studio, which is used to build a site, and ColdFusion Server, which serves the pages to users. ColdFusion Studio is described as "a complete integrated development environment (IDE)" and ColdFusion Server as "a deployment platform."
The most valuable feature for many companies that use ColdFusion is the ability to build Web sites as "piece parts" that can be stored in a database and then reassembled for Web pages, e-mail newsletters, and other uses. ColdFusion provides a visual interface for building Web pages directly or for building the "piece parts." For example, a newspaper with a Web site can have a reporter enter a story, dateline, author, and other information, using a text entry form free of all Web page formatting and structure details or language tags. (The newspaper uses ColdFusion to design the forms and to define the database.) The content entered by the reporter is later gathered and formatted into a Web page when it is requested. The reporter is free from having to understand HTML and other details. ColdFusion is also a popular tool for building e-commerce sites.
ColdFusion has its own page markup language, called ColdFusion Markup Language (CFML). CFML encompasses the Web's Hypertext Markup Language (HTML) and Extensible Markup Language (XML). A just-in-time (JIT) compiler turns the CFML into the pages that get served. Allaire emphasizes that their product set is open and "extensible". Applications can access databases using Microsoft's OLE DB, Open Database Connectivity (ODBC), or drivers that access Oracle and Sybase databases. ColdFusion can be coordinated with distributed applications that use Common Object Request Broker Architecture (CORBA) or Microsoft's Distributed Component Object Model (DCOM) to interact with other network applications.
Allaire also says that ColdFusion is scalable, allowing both the size of a database and the number of users that can be served to grow. For large Web sites, multiple ColdFusion servers can be run together as a cluster
Regards
Raghu
- From: Raghu (@ 217.158.120.226)
on: Tue Sep 10 12:03:24
any body out there knows SQL server 7 / SQL server 2000, I am very good at SQL scripts TSQL, etc, but have no idea about scheduling, please help.
thanks
- From: Raghu (@ 217.158.120.226)
on: Tue Sep 10 12:03:48
oops, here is my email ID
- From: blurblob (@ pcproxy2.singnet.com.sg)
on: Thu Sep 12 08:18:22
Hi Raghu, thanks alot for the explanation and yr precious time. I'm currently doing a computer science course. I'm keen in learning more about creating a professional website. Thus far I've only learned how to create websites using HTML and Javascript. However, I think these are not enough to create a real dynamic websites. Any advise on the basic essentials of building dynamic websites for organisations? Can't seem to get enough info from lecturers or reference materials :)
- From: Raghu (@ 217.158.120.226)
on: Thu Sep 12 12:07:39
blurblob;
if u drop me an email, I can give u some articles, which I can attach as an attachments.
c u
Tell your friend about this topic
Want to post a response?
Back to the Forum