Return Dictionary From A Function

im trying to create a function that accepts a sql statement as a parameter,
makes a db connection, returns a recordset, and inserts all items from the
recordset into a data dictionary - then i want to set the value of my
function equal to my newly created dictionary of items from the recordset -
this is where im having a problem. is it possible to set a function equal
to a dictionary? i cant seem to make this work and it seems that this
should be possible.

here is some sample code:

View Replies


ADVERTISEMENT

Use 'return' In A Function

When should we use 'return' in a function to return the result versus 'FunctionName = result'

View Replies View Related

Return A Value From Function

Code:
function findcinemaid(nameofthecinema)
findcinemaid = "select cinemasid from cinemas" &_
" where brand = 'tgv' and cinemaplace2 like '"&nameofthecinema&"'"
set cinemaidfound = objconndb.execute (findcinemaid)
optainedcinemaid = cinemaidfound("cinemasid")
end function

tgvcinemanamexcel = "[1u_f$]"
cinemaname = "ONE UTAMA"
findcinemaid(cinemaname)
response.write optainedcinemaid

if I put response.write inside funciton it will display the cinemaid properly but if I put it outside , it wont display

View Replies View Related

ASP Function To Return Value From Access DB

i am trying to write a function which will add an entry to to a table in my DB
and then return me one of the values of the newly added entry.

For e.g. I use the function to add a new Order Entry into the DB, but i would also
like the function to return me the value of the OrderID field for the new entry. Code:

View Replies View Related

VB Function To Return Array To ASP

I need a VB function to return array of collections like

Private Type Employee
empname as string
address as string
salary as integer
deptno as integer
End Type

dim employees() as Employee

Public Function getEmployees() as Employee()
getEmployees=employees
End Function

I will call that function in ASP.This was not working any other method is welcomed.

View Replies View Related

Any Way To Return Function Of Date

is there a way to 'force' ASP date function to return date in a given format; I mean, my need is to force 'date()' function to give me system date in italian format instead of english (O.S. is in english as well as locale settings for IIS anonymous user); is there a directive or something similar to put in ASP code?

View Replies View Related

Function Return Breaking For Loop

Can anyone tell me why the funciton checkCode returning in the middle of the for loop breaks the for loop? ie. If I remove the section:

if checkCode("0011") = 1 then
response.write "<br />Passed submission of user code"
else
response.write "<br />failed submission of user code"
end if

from the code snippet below, then the code will successfully loop through and print out all the post var fields (there are in fact 4).

If however you leave this in, the function returning seems to break the for loop from continuing through all the other post variables after "user_code" Code:

View Replies View Related

Dictionary

I am working on a project which
used dictionaries. I am having
to remake part of this and have
no experience with the
scripting dictionary.
I need to see how to create multiple
dictionaries within one dictionary.
Can someone point me to some
reading materials on this where I
might see an example as well?

View Replies View Related

Dictionary Searching

Just wondering the best way of doing this? are there any dictionary databases laying around somewhere?

I want to change my search so that it corrects typo's and maybe suggests better words to search with... like googles but with more alternative words to make the search more useful - slightly limited so it doesn't become pages and pages of search terms.

What I don't want to do is sit down in front of my computer and type all of this in, going through related words and possible other searches / best searches from the given input.

View Replies View Related

ASP Dictionary Object

While pouring over some code I've discovered a previous developer heavily
uses the "dictionary" object. Whilst I see some of the advantages of using
this system It's something I've not used myself so am not sure of the
limitations.

We are about to widen the scope of the website it's being used on to a
WorldWide system - greatly increasing the number of users that will be using
the website.

What I'd like to know is are there any performance issues with using this on
a heavily used site?

View Replies View Related

Online Dictionary...

I'm planning to construct an experimental mini online dictionary. The core of the dictionary is, of course, the smart 'search' function.

So I'd like to know if it would be better to use asp instead of php for such a search function (and...why!).

View Replies View Related

Dictionary Object

I am trying to store some data in a Dictionary object. I am getting errors though about adding duplicate keys. "key already exists"

I commented out the obj.add and just did a .write of what exactly was being added each time. There never was a time when a key was being added twice ....

View Replies View Related

Send Dictionary

I proceed much further whether it is possible to pass in the Dictionary object (Scripting.Dictionary) from ASP to a stored procedure in SQL Server. Any sample sites or simple code examples would be really great.

View Replies View Related

Dictionary/Solution!

I need an ASP dictionary/glossary script. I saw a bunch of options online for PHP but almost nothing for ASP. I'm not a programmer....but can install working code and connect a database. can anyone recommend a tutorial or even better a finished working piece of code I can implement to create my own dictionary with custom definitions?

View Replies View Related

Add Words To Dictionary

I have to develop a spell checker from scratch using asp language. as i'm a newbie with asp, there are still a lot of things that i don't understand. How can I add new words to my list of dictionary sorted alpabetically?

Do i need to use the database for this function? Can anyone show me? or if anyone knows of any websites that i can refer to.

View Replies View Related

Dictionary Issue

I'm using a dictionary to record some totals, however, my first attempt
failed and I wasnt sure why...

snippet from original code:

oTotalFilters.Item(rsNetStock.fields("PartNo")) =
oTotalFilters.Item(rsNetStock.fields("PartNo") ) + CInt(iNumFilters)

After going back to the start, I eventually realised that the dictionary
Item property didn't like 'rsNetStock.fields("PartNo")' as a parameter, so I
had to use something like the following:

sTest = rsNetStock.fields("PartNo")
oTotalFilters.Item(sTest) = oTotalFilters.Item(sTest) + CInt(iNumFilters)

Am I missing something here? Surely, my original code should have worked?

Is this a known bug/feature?

View Replies View Related

Scripting.Dictionary

I'm trying to use the Scripting.Dictionary. However the item I'm adding to the dictionary is an array. An example is

Set objD = CreateObject("Scripting.Dictionary")
objD.Add "Key1", Array(1,2,3,4,5)

I know for sure the array always has 5 items. In VBScript, I can access the item like this:

objD.item("Key1")(1) to objD.item("Key1")(5)

View Replies View Related

Order A Scripting.Dictionary

I have a problem with the Scripting.Dictionary in ASP.
All my data is entered into my Dictionary with no order and I would like to order them alphabeticaly and I don't know how to do.

View Replies View Related

Accessing Key Name In Dictionary Object

Have created a dictionary object that gets both the key name and the value from a database.

I need to be able to output both the key name and the value.

I can get it to display the item value, but am unable to get it to display the key name. Should look like this

KeyName = Value
e.g.

1 = J5200
2 = S5362

View Replies View Related

Dictionary Scipting Error

having problem with dictionay scripting when i changed data base that
uses N'S AND Y'S INSTEAD OF 1'S AND 0'S AND I GET THIS ERROR,

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: "Y"]'

/PICKLER/cm/delay_info_cm.asp, line 154

LINE 154 READS Code:

View Replies View Related

Case-insensitive Dictionary

I need something like Scripting.Dictionary. but with case insensitive keys, i.e.

dict.Item("mykey") and dict.Item("MyKeY") should be identical.

View Replies View Related

Random Dictionary Item

I'd like to be able to select a random key/item, is this possible with the dictionary object, or would I be better using an array?

View Replies View Related

Array Of Dictionary Objects

I'm having problems with an array of dictionary objects. It is being used to organize an SQL catalog set up with an ID/ParentID scheme. The script uses recursive functions to return the children categories, and works fine except for storing the info in the array of dictionary objects.

The UBound of the array is correct, and the very last index (93) to the array seems to have the correct dictionary object, but all the previous (0-92) come up with "Object Required:" error. By the way, dicRecords is another array of dictionary objects taken from a recordset. Any ideas? Code:

View Replies View Related

Scripting Dictionary Vbscript

i'm trying to page through the items in the Dictionary, i've got a great example on it, but the way my class and dictionary is set up won't allow me to use the example Code:

View Replies View Related

Word.Application Dictionary

I'm using Server.CreateObject(Word.Application) to execute a spell check. Works fine, but we'd like to add a few of our more common company-isms to the dictionary, as they're getting flagged every time.

I tried opening Word on the Server and adding one to the dictionary. I also tried it locally (which didn't make any sense, but still). The word still shows up as an error. Is there a way to customize this dictionary?

View Replies View Related

Exception When Accessing Dictionary Object

I have a server running Windows Server 2003, on which two of the web
sites use the MegaBBS ASP forum software. Both sites suddenly developed
the same error, which seems to be connected to the dictionary object.

ASP... Code:

View Replies View Related

Can JavaScript Add Items To ASP Dictionary Object

I got two ASP pages. One is ASP email form (I'm using Persist ASP
Email component). Another one has all file links in it. For example,
when user click Outlook course hyperlink. It will pop up another
window with outlook course PDF file. (All PDF files are already in the
server).

What I am trying to do is: When user click the "Add Email" hyperlink,
it will add that course name and filepath into ASP/VBScript Dictioanry
Object. After the user finish and click "Attach to email" button. All
the files will be attached in the email as an attachment.

Because I am not familar with VBScript. So, can Javascript add items
to ASP Dictionary Object?

View Replies View Related

ASP, ADO And Dictionary Object Runtime Problem!

I have used a VBScript dictionary object to load column names and their values so I can use them when I build the web page.

When I do this, I get the correct value printed on the page:

<%Response.Write("Company Name is: " & objDict.Item("companyname"))%>

But, when I try to use it in an HTML tag, like this, I get a runtime
error '800a01b6' - Object doesn't support this property or method:
'Item':

<input type="text" maxLength=60 size=60 name=comName
value="<%objDict.Item("companyname")%>"></input>

Why does it work in one form and not the other?

View Replies View Related

Dictionary Object Error '80020009'.

I'm getting an '80020009' error when I try to display items from my dictionary object. Code:

View Replies View Related

Scripting.Dictionary & Possibly 0x80020009

Ok, first I had a problem with that error code: 0x80020009, but this article
http://support.microsoft.com/defaul...b;EN-US;q175239 fixed that. I'm saying this
because it might still have an impact..... I don't know.

I'm using scripting.dictionary for my webshop, so I'm putting the scripting object in a session variable.

So you can order three types of things, and I have one page that lists your shopping cart before checkout.

When I display only one of the three types (ie delete the rest from the file) it's all good. when I try to display them all, stuff just dissapears. If it wasn't for the fact that it works with one type, I would have thought it was something with some of the if syntaxes. Code:

View Replies View Related

Dictionary Object Pass Values

Is it possible to pass Dictionary object keys and values to another page? If so, how?

I know how to store the items, but specifically, how do I pass the values and retrieve them on another page

View Replies View Related

Dictionary Object Creat New Dictionory

I have a dictionary object,then I create a new dictionary object and sets it equal to my original,then I pass the new dictionary object to a function that changes some of my values - but then my original dictionary also gets changed and that was not the intention.

can someone explain to me why it behaves that way and how do I avoid it.så I van have different dictionary objects?

View Replies View Related

Shopping Cart With Session Or Dictionary

How to built a small shopping cart using Session OR Dictionary ?

View Replies View Related







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