How To Save Multi-name Into One Field, And Display Only One

From my system, it allow product has multi-category, so I need to save
all category names which one product belong to into one field on a
database,

and record saved like " nameA|nameB|nameC " - seperate by "|".

question 1:

the second time when i update the record for same product name, how to
have a record
like "nameA|nameB"

After multi-category name saved, then, i would like to generate a
navigate name with the link like

home > nameB > name of product

question2:

so how can i retrieved only one name from category field.

View Replies


ADVERTISEMENT

Save Db Records Of A Field In An Array

I want to save db records of dates in an array something like the below(I know it's wrong, i'm just trying to describe what I want)... Code:

View Replies View Related

Read The Content Of Db[ms-sql] Field N Save It As A File

is it possible to read the content of a db[ms sql] field and save the content as a file[e.g: .bmp]

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.

THIS IS THE CODE: ....

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.

Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb

When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record
and Keith Robb into the 2nd record in the recordset.

Does anyone see what is wrong with the code ....

View Replies View Related

Multi-field Database "order By"

Is it possible to retrieve data with ASP sorted on 2 fields? I've tried :

SELECT * FROM [TableName] ORDER By Field1 AND Field 2

But it gives an error. I've searched the internet on this topic to no avail.
Is it possible?

View Replies View Related

Display Data From Field

I tried to Display data from field DB (mysql) into a Textarea to edit the text. The code I used is : Code:

<textarea name="warranty" cols="90" rows="6" class="style55" value="<%=WARRANTY%>" type="text"></textarea>

And it does not displays the data.?

View Replies View Related

Display A Portion Of A Field

I need to display only a portion (like the first 100 characters) of a field in a database. I don't recall how to do this.

View Replies View Related

Formatted Display Of Memo Field

I am using access Memo field to store text of large size. If I use <%=memofield%> in simple display, it does not look like a formatted field and all text comes in a single line without any break.

Even If the text is same like what I am posting in this thread, out come will not have break in browser's display.

View Replies View Related

Display Screwing Up If Field Is Empty In DB

I so thought I had this down and I was getting excited, but when I ran it, it didn't work. I've tried a few different things and I can't get it to work (not smart enough I guess). Code:

View Replies View Related

Display Related Access Field

I have a timesheet application I'm working on. The user fills in a form which sends data to an Access db. On the results page I need to display the values from 2 fields; i.e if the user selects "Report Writing" from a drop down list, I need the data contained in another column called 'Codes' to display as well.

View Replies View Related

Display DateTime Field From Access In UK Format

I have a DateTime stamp in one of my Access database columns. Using now() as the default value, it enters records in the following format:

17/06/2005 14:28:40

This is perfect. UK format, just as I want.

However, when I pull this record into an ASP page it appears in a different format:

6/17/2005 14:28:40 AM

How can I stop it from re-writing the data into American format? I just need to display it exactly as it is in the database.

View Replies View Related

Display VBScript Function As Text Field

I have a VBScript function:

<script language="VBScript" type="text/vbscript">
Function Main()
set wshshell = createobject("wscript.shell")
struser = wshShell.ExpandEnvironmentStrings("%USERNAME%")
strdomain = wshShell.ExpandEnvironmentStrings("%USERDOMAIN%")
msgbox struser & strdomain
End Function
</script>

That works great as a Active X script but I want this to display as a value in a text field and I can't find how o do that.

View Replies View Related

Changing Display Of Auto Date Field

i have a field in my form which auto adds the date to my database, its inputs as 1/09/2007 and what im after is when i retrieve that data to be displayed i would like the date to be displayed as 9th September 2007,

View Replies View Related

Getting Record Increment To Display In Form Field

How would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:

View Replies View Related

Parse A String From A Field And Display In Table

I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)

I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on

I'm using ASP, VB Script with DMSII Database and OLEDB

Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?

View Replies View Related

Doesnt Display Char Type Data Field Length 1

I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.

I'm running query:

"select * from table" and fetching all the records and displaying...

It display all the data except data from this field..Doesnt display anything..

I had put Response.write rs("fieldname")

What could be the problem?

View Replies View Related

Multi-purpose DLL

I released to open source a while back but forgot to post in here a DLL that was used in some of our older developments. It's not really a live project, but may be of use to peeps in here given some of the recent queries:Quote:

DBSite: Written in Visual Basic this DLL helps solve issues for ASP web developers, e.g. handling uploads, safe parameter population for stored procedures (sql injection checks), SQL XML calls, file system browsing, etc.

View Replies View Related

Multi-language

I was trying:
Code:
<!--#include file="lang/<%= Request.QueryString("lang") %>.asp"-->
But it doesn’t work.

View Replies View Related

Multi Tab Page

How can i create a multi tab page in asp.net 2.0?
create a frame and a number of page with hyperlink?
Would i have some directives?

View Replies View Related

Multi Tables

How can I update/delete a record which is linked to another table with a
unique field. I know the select inner join, but no update/delete.

View Replies View Related

Multi-join

Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.

View Replies View Related

Multi Page

I need to create in asp/access/javascript a questionnaire that shows a single question on each page of which there are five then after the last question create a new record in the access db and write the answers.

View Replies View Related

Multi Updates

lets say we have a ms db with two cols

id value
1 4
2 7
3 9
4 1

is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.

View Replies View Related

LEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause

I am using a Relational database for my site and i have the following tables:

FIXTURES, GAMEDATES

the fields in FIXTURES are:

GameDate
Home
Away

(All of the above are numerical fields)

the fields in GAMEDATES are:

DateID(integer)
GameDate(#Date Field#)

What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)

The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:

WHERE Fixtures.GameDate<=(Date())

obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.

The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.

Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data

View Replies View Related

Multi Database Connection

I have written a asp application whihc uses a number of pages and each page connects to a sql database.
Currently I have the connection script coded on each page however if i need to change the database I have to change every page.
I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page

View Replies View Related

.:·Dynamic Multi-dymansional

As part of the development of a shopping basket function, I've a two dimensional aray which I'm storing in the session variable.
I want the array to be dynamic to store any amount of products which may added.

I am getting a problem when trying to write to the second row to the array, saying that the subscript is out of range...
You can see an example of this at:
http://www.foulkestudios.com/session.asp

I am getting what should be the first empty row by getting rows=UBound(myArray,2)
I'm then trying to add into the next row by using rows + 1

View Replies View Related

Multi-user Applications

I am b-testing a community site, with currently 1,000 or so membership,
and low concurrency, say no more than 5 on-line at once.

The site is hosted on a shared server, which is sufferening from
intermittent accute slowness, affecting all other hosted sites as well as
mine.

The finger of suspicion is pointing at me and possible sloppy code. As
this is the first site I have done of this nature, could someone recommend
reading matter (knowledge bases etc), especially coding samples, in
connection with data connections (opening and closing connections and
objects) and record locking issues, which if improperly coded, could
contribute to throughput bottlenecks due to inefficient use of resources so
that I can check out my pages and correct any nasties..

View Replies View Related

Multi-server Code

I am think to write a code that will need more then 2 servers.

Can anyone give me some information to do code like that?

Like yahoo, google, msn.

View Replies View Related

Multi-page Application

I need to develop an application that will span 12 or so pages, and on the
last page, it lets the user review the data and then insert it all. This is
kind of like selling something on eBay, you give it information, click next,
enter more info and then at the end you review and submit the item. I was
thinking about sessions, but some of the fields are pretty big, like
varchar(5000) so I didn't know if there was a way to handle these big
fields.

View Replies View Related

Multi-Lingual Web Site

I am in the process of developing several web sites that will accommodate up to 3 or 4 languages. The sites are not that complex, but will use an Access database for some data presentation/storage. Each page will have a series of flags for respective languages. Ideally, if someone enters on a "gateway" page for say Gallery, and they choose another language, I would like the same page to display but in a different language (there might be a page for each language, but if I can avoid that I'd rather).
So here are my thoughts on how to approach this. Have a session var for language preference and set it in a Global.asa file. I would think it could be set dependant on the origin of the request, .de, .co.uk, .it, etc. Then, if the code is not too verbose, use Case statements in the code to display content based on language preference. One thing of a bit challenging for me is that if the "flags" are in an include file, how can I get them to when clicked go to a script, change the session variable and return to the page from which it was clicked. Am I on the right track with this approach.

View Replies View Related

Multi-page Displaying

I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc.
How do I go about actually filtering the database to only produce 10 results per page? I was trying to use:

results.Move 10

and things like that, but I'm not sure of the best way around this.

View Replies View Related

Multi Record Update

I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved